How to count the number of duplicate items in a table?
Answer Posted / mr.abdul rahim
select count(column), column from table group by column
having count(column) > 1
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is clustered vs nonclustered index?
What are different replication agents and what's their purpose? : sql server replication
Tell me something about security and sql azure?
Explain transaction server implicit?
What is the difference between mysql and mysqli?
What is dynamic cursor in SQL SERVER?
Explain the benefits of user-defined functions?
What are the advantages of policy management?
How to divide query output into multiple groups with the group by clause in ms sql server?
How to drop an existing table?
How do you set a trace flag in sql server?
How to change the system date and time from SQL Plus Terminal ?
What is BLOCK statements in SQL?
Is it possible to update the views? If yes, how, if not, why?
What is the difference between left and right outer join?