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
How will you find out if there are expensive SQL statements running or not?
What are the disadvantages of merge replication?
How to create a user to access a database in ms sql server using "create user" statements?
Explain Capacity planning to create a database? and how to monitor it?
When would you use sql joins?
Explain few examples of stored procedure over triggers?
What is replication and database mirroring?
What is a field name?
how you can get the list of largest tables in a database? : Sql server administration
How do you migrate data from mssql server to azure?
What is the federation in sql azure?
How can I check that whether automatic statistic update is enabled or not?
How do I create an extended event in sql server?
Who is the owner of a schema in ms sql server?
State the difference between local and global temporary tables?