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 purpose of grouping data in a report?
What is a fill factor?
How to connect to a sql server using odbc_connect()?
Explain can SSRS reports Cache results?
What is the impact on other user sessions when creating indexes?
What are sub reports?
Why use stored procedures in sql server?
Why olap is used?
What is transaction server auto commit?
Do you know query execution plan?
How to transfer an existing table from one schema to another schema in ms sql server?
How to create a simple user defined function in ms sql server?
Can group functions be mixed with non-group selection fields in ms sql server?
How to create stored procedures with parameters in ms sql server?
How do you know if sql server is running on your local system?