QUESTIONS INTERVIEW.IN

Post a Question

Asked Questions

Question Bank

Home

 
Category
- Php
- JAVA
- DOTNET
- Vbscript
- C
- vb
- html
- Javascript
- Mysql
- Oracle
- Sql server
- sql
- Db
- Cost Accounting
- Computer
- Commerce
- Clarify CRM
- Business
- Aerospace
- Algorithm
- Arts
- Certifications
- Cashier
- Call Center
- Audit
- Bluetooth
- Banking
- Data Structure
- Accounts
- Math
- Physics
- Chemistry
- Biology
- Others

Home >> Asked Questions >> Mysql

Q. How to delete duplicate records mysql query ?
 
 


Answer :
DELETE e1 FROM EMPLOYEE e1, EMPLOYEE e2 WHERE e1.name = e2.name AND e1.id > e2.id;
Posted By : aman
Post Answer :  
Answer * :
Are You? Already Member New User
   
User Name / Email * :
Password * :
Security Code * :

(Enter security code above shown on image)
Most Viewed Questions
display html tags
Free directory list.
How can display google chat on my website?
How can open multiple window?
How can display goggle map on my website?
How to create connection in php to Oracle
Short form of if statement
How can create a tree in php
How can upload image on tiny mice editor?
How to change scroll-bar
Missing argument 1 for display_message()
How can delete mozilla firefox cookie?
How does a MYSQL Self-Join Work?
Firefox is currently in offline mode and can't browse the Web.
HOWTO Fix Fatal error: Call to undefined function: mysql_connect()
Parse error: syntax error, unexpected T_VARIABLE
how can write between query in mysql?
inner join in mysql
How can delete last element of the array?
How To Add Your Site to Bing Site
 
PHP
Dotnet
Privacy Policy
Site Map