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

How to find index size for each index on table?

980

How to find Duplicate Records In table?

984

What are the advantages of having an index on the sql server?

889

What is sql server replication? : sql server replication

946

Can you move the resources after pausing the node? : sql server database administration

1056

How to insert a new row into a table with "insert into" statements in ms sql server?

932

Do you know what is sql service broker?

1023

What is dknf in normalization form?

1006

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1053

How does Report Builder support Analysis Services cubes?

151

How to write a query with an inner join in ms sql server?

1016

Name three of the features managed by the surface area configuration tool? : sql server security

958

What are the system database in sql server 2008?

1000

What types of replication are supported in sql server?

1021

How will you add a dimension to cube? : sql server analysis services, ssas

1048