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 use order by with union operators in ms sql server?

1002

What are the types of processing and explain each? : sql server analysis services, ssas

1135

What is a rollup clause?

953

Define primary key?

1114

Can we use where clause in union?

1045

List out what other servers you can use with ssrs?

137

What is the purpose of forms?

936

What is sub-query in sql server?

1186

Explain filtered indexes?

974

How to integrate the ssrs reports in application?

964

What is the difference between resultset and resultsetmetadata?

937

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

1999

How to use values from other tables in update statements in ms sql server?

1092

How can we use ConnectorJ JDBC Driver with MS SQL?

985

Difference between report and query parameter.

1061