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

Why use update_statistics command in sql server?

1061

Define views.

1017

What is for xml in sql server?

1082

Where do you find the default Index fill factor and how to change it?

1064

Can you leave a union at any time?

1064

how many triggers you can have on a table? : Sql server database administration

979

If a stored procedure is taking a table data type, how it looks?

6451

What are the different types of locks in the database?

925

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1010

Can you please explain the difference between function and stored procedure?

1013

what is difference between view and Dip.

2412

How to find out the list schema name and table name for the database?

942

What is a non-clustered index?

999

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1129

Explain filtered indexes?

1005