How to count the number of duplicate items in a table?
- 3 Answers
- 7953 Views
- I also Faced
- E-Mail Answers
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 ROW_NUMBER and Ranking function in SQL SERVER?
How many types of triggers are there?
Does transparent data encryption provide encryption when transmitting data across the network?
Does order by actually change the order of the data in the tables or does it just change the output?
What is checkpoint in sql server?
What objects does the fn_my_permissions function reports on? : sql server security
Explain various On-Delete options in a DB table. Which is the default option?
What is nested transaction?
How to achieve Paging of records in SQL SERVER?
How to use user defined functions in expressions?
What are different types of roles provided by ssrs?
What are the elements of dbms?
What is extended stored procedures?
Explain partitioned view?
What are null values in ms sql server?
