select count(*) from (select boss_ID,COUNT(boss

How to count the number of duplicate items in a table?

Question Posted / lalit goyal

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

Please Help Members By Posting Answers For Below Questions

Should you normalize audio?

1004

How do you delete duplicate records in sql server?

1126

Some queries related to SQL

1036

What were the latest updates to SQL Azure service?

113

How to list all schemas in a database?

1100

What is partition index in sql server?

1171

what is a join? : Sql server database administration

1325

Can I delete event logs?

977

How to find the login name linked to a given user name?

1059

What is always encrypted?

1055

What is the importance of three tier architecture?

1141

What happens if you delete a table that is used by a view?

1061

How do you send email on SQL Server?

1116

What are the steps you must follow to hide sql server instances?

1024

What is a transact-sql statement batch in ms sql server?

1071