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
- 32189 Views
- Leo Technologies, Mannar Company, Synechron, I also Faced
- E-Mail Answers
Answer Posted / dilip
Ans for 1st Query
How to retrieve duplicate rows in a table?
SELECT * FROM EMP1 WHERE (EMP_ID IN (SELECT emp_id FROM
emp1 GROUP BY emp_id HAVING COUNT(emp_id) > 1))
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
What is the difference between stored procedure and functions?
What are the different methods available under sqlcommand class to access the data?
What are sub reports and how to create them?
What are 3 ways to get a count of the number of records in a table?
How to execute a stored procedure in ms sql server?
What is analysis service repository?
What is the size of transaction log file?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
How to execute stored procedure in select statement sql server?
How to check if stored procedure is running in sql server?
What are the different types of collation sensitivity?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is a livelock?
What are the types of sql server?
What are the types of subscriptions in SQL Server replication?
