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 will you find out if there are expensive SQL statements running or not?

1071

What are the disadvantages of merge replication?

1512

How to create a user to access a database in ms sql server using "create user" statements?

996

Explain Capacity planning to create a database? and how to monitor it?

4243

When would you use sql joins?

1028

Explain few examples of stored procedure over triggers?

1115

What is replication and database mirroring?

1088

What is a field name?

1017

how you can get the list of largest tables in a database? : Sql server administration

1100

How do you migrate data from mssql server to azure?

167

What is the federation in sql azure?

How can I check that whether automatic statistic update is enabled or not?

1093

How do I create an extended event in sql server?

1002

Who is the owner of a schema in ms sql server?

1116

State the difference between local and global temporary tables?

1168