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

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

950

What is the recursive stored procedure in sql server?

968

When is the use of update_statistics command?

953

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

944

What are window functions in sql server?

940

What are the source of constraints?

860

What is data set in report?

121

What command would you use to add a column to a table in sql server?

1236

What are the mathematical functions supported by sql server 2005?

998

How do I create a stored procedure in dbml?

928

Explain few examples of stored procedure over triggers?

964

How to list all columns in a table using odbc_columns()?

937

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

907

How to enable tcp/ip protocol on a sql server?

1094

What is sql profiler. What are the default templates with it? : sql server database administration

953