Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table?
- 15 Answers
- 33020 Views
- Leo Technologies, Mannar Company, Synechron, I also Faced
- E-Mail Answers
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 a sub-report?
What is recompile sql server?
What are the types of database recovery models?
Does sql server use t sql?
How would you add a section to a table?
How to concatenate two character strings together?
How to update multiple rows with one update statement in ms sql server?
How do I view a stored procedure in sql server query?
Do you know what is fill factor and pad index?
How many types of subqueries are there in sql server?
A trigger can reference objects outside the current database? State true or false.
How to retrieve error messages using odbc_errormsg()?
List some advantages and disadvantages of stored procedure?
what is spatial nonclustered index
What is a collation?
