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


Please Help Members By Posting Answers For Below Questions

What is clustered vs nonclustered index?

716


What are different replication agents and what's their purpose? : sql server replication

773


Tell me something about security and sql azure?

112


Explain transaction server implicit?

725


What is the difference between mysql and mysqli?

783


What is dynamic cursor in SQL SERVER?

771


Explain the benefits of user-defined functions?

757


What are the advantages of policy management?

771


How to divide query output into multiple groups with the group by clause in ms sql server?

786


How to drop an existing table?

760


How do you set a trace flag in sql server?

791


How to change the system date and time from SQL Plus Terminal ?

899


What is BLOCK statements in SQL?

1021


Is it possible to update the views? If yes, how, if not, why?

735


What is the difference between left and right outer join?

762