How to count the number of duplicate items in a table?
- 3 Answers
- 7960 Views
- I also Faced
- E-Mail Answers
Answer Posted / lalit goyal
select count(*) from (select boss_ID,COUNT(boss_ID) as s from dbo.Employee group by boss_ID ) a where s>1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I create a stored procedure in dbml?
How do you manipulate data?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
How do you make a trace?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What is the sql profiler?
How to delete duplicate rows?
How to maintain a fill factor in existing indexes?
What is query parameter in ssrs?
How do I run a trace in sql server?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
List the different normalization forms?
What is service broker?
What are the components of sql server service broker?
How do you check sql server is up and running?
