How to count the number of duplicate items in a table?
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 |
Post New Answer View All Answers
What is star, snowflake and star flake schema? : sql server analysis services, ssas
What is meant by dirty read?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
What are the different types of join?
when you create a database how is it stored? : Sql server database administration
Why use triggers?
What are pages and extents? : SQL Server Architecture
How many tables can be joined in SQL Server?
What happens if the update subquery returns multiple rows in ms sql server?
What does executeupdate return?
What is the difference between a stored procedure and a user defined function?
What is b tree index?
What is the difference between for xml raw and for xml auto?
Can a table be moved to different filegroup?
Why use stored procedures in sql server?