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 the difference between delete table and truncate table commands? : Sql server database administration

755


Do you know what is a with(nolock)?

838


Is sql server is free?

753


How to include text values in sql statements?

810


Explain how you can deploy an SSRS report?

124


Define outer join in sql server joins?

724


What is sql server english query?

799


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

2378


you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

779


What are the recovery models in sql server 2000?

749


How except clause is differs from not in clause?

760


What is the difference between a function and a stored procedure?

800


What are the new features of sql server 2012 reporting service?

101


How to list all columns in a table using odbc_columns()?

780


Difference between Sql server reporting services and Crystal reports?

139