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
what is the difference between delete table and truncate table commands? : Sql server database administration
Do you know what is a with(nolock)?
Is sql server is free?
How to include text values in sql statements?
Explain how you can deploy an SSRS report?
Define outer join in sql server joins?
What is sql server english query?
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?
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
What are the recovery models in sql server 2000?
How except clause is differs from not in clause?
What is the difference between a function and a stored procedure?
What are the new features of sql server 2012 reporting service?
How to list all columns in a table using odbc_columns()?
Difference between Sql server reporting services and Crystal reports?