How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table?
Answer Posted / pawan k. dubey
delete from employee
where Emp_id not in (select min(Emp_id) from employee
group by Emp_Name)
| Is This Answer Correct ? | 2 Yes | 12 No |
Post New Answer View All Answers
Do you know what are the properties of the relational tables?
Where views are stored in sql server?
What are system databases into sql server (2005/2008) : sql server database administration
How to fetch the next row from a cursor with a "fetch" statement?
What happens if the update subquery returns no rows in ms sql server?
Can we use trigger new in before insert?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What are the advantages of partitioning?
How to create an index on a view?
What is master database? : SQL Server Architecture
What is data source in connection string?
How to list all schemas in a database?
What is the library index called?
How secure is sql server database?
What is user-defined multi-statement table-valued function?