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
Is resultset an interface?
Tell me what is de-normalization and what are some of the examples of it?
What do you mean by data manipulation language?
Are resultset updatable?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
How to concatenate two character strings together?
What is the difference between implicit and explicit transaction?
How many levels of sp nesting are possible?
What is dknf in normalization form?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
How do I start sql server 2016?
What are the advantages of mirroring?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What is index, cluster index and nonclustered index?
What is the difference between writing data to mirrored drives versus raid5 drives