select count(column), column from table group by column having count(colu

How to count the number of duplicate items in a table?

Question Posted / mr.abdul rahim

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

Please Help Members By Posting Answers For Below Questions

How to convert binary strings into integers in ms sql server?

1030

How to list all field names in the result set using mssql_field_name()?

914

What is database architecture? : SQL Server Architecture

1045

What stored procedure can you use to display the current processes?

893

What is a partitioned view?

991

Explain how to use linked server?

992

How to make remote connection in database?

1007

How can we rewrite sub-queries into simple select statements or with joins?

981

What is table-valued sub query?

969

What are the components of sql server service broker?

1016

Where cross join is used?

964

You are doing log shipping due to some reasons it is failing. How you will proceed from there

2069

Explain what is public role in sql server?

1135

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

989

What happens to a statement batch if there is a compilation error?

969