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
How to find index size for each index on table?
How to find Duplicate Records In table?
What are the advantages of having an index on the sql server?
What is sql server replication? : sql server replication
Can you move the resources after pausing the node? : sql server database administration
How to insert a new row into a table with "insert into" statements in ms sql server?
Do you know what is sql service broker?
What is dknf in normalization form?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
How does Report Builder support Analysis Services cubes?
How to write a query with an inner join in ms sql server?
Name three of the features managed by the surface area configuration tool? : sql server security
What are the system database in sql server 2008?
What types of replication are supported in sql server?
How will you add a dimension to cube? : sql server analysis services, ssas