How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table?
Answer Posted / madhur/amrutha
Consider a table emp with employee details. The Correct
code to retrieve duplicate rows :
select distinct * from emp where names in
(select names from emp group by names having count(sal)>1)
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the benefit of normalization?
What are the essential components of sql server service broker?
What are triggers? How do you invoke a trigger on demand?
How to create a view on an existing table in ms sql server?
What is an index. What are the types?
What is replace and stuff function in sql server?
How to select some specific rows from a table in ms sql server?
What is autocommit mode in sql server?
What is an sql server agent?
Can sql servers link to other servers like oracle?
What are the benefits of filtered indexes?
what kind of lan types do you know? : Sql server database administration
How do I install sql server?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What are the diifferences between the ms sql server vs mysql?