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

What is difference between rownum and row_number?

917

What is an inner join?

924

What is the difference in accessing db between sql server vs sql azure?

174

What is an indexing strategy?

956

Other than truncate statement, which other command can by-pass the trigger on the tables?

1079

How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?

163

How to create an multi-statement table-valued function?

946

How to provide default values to stored procedure parameters?

1016

Do you know what are the reporting services components?

931

What are the kinds of subquery?

963

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1108

How to provide values to user defined function parameters?

980

Will sql server 2005 allow you to reduce the size of a column?

929

Explain what is use of dbcc commands?

998

How many types of keys are there?

975