Select Emp_Id, Count(Emp_Id) From Employee As Emp Group By Emp

i want only duplicates rows from coloumn
ex. emp_id(colomn name)1,1,2,3,3,4,5,5.

so i want only duplicates no.

Question Posted / kumar.t

Answer Posted / kumar.t

Select Emp_Id, Count(Emp_Id) From Employee As Emp
Group By Emp_Id
Having Count(Emp_Id)>1

By
Kumar

Is This Answer Correct ?

17 Yes

2 No

Please Help Members By Posting Answers For Below Questions

do views contain data ?

911

How to convert numeric expression data types using the cast() function?

1001

How to create a testing table with test data in ms sql server?

1012

How to change a login name in ms sql server?

1023

What do you understand by sql server agent?

902

Write down the syntax and an example for create, rename and delete index?

923

What is the command to change the recovery model?

996

Tell me what are cursors and when they are useful?

909

can an automatic recovery be initiated by a user? : Sql server administration

892

What are ddl triggers and types of ddl trigger?

974

Define left outer join in sql server joins?

903

What is create statement?

881

What does the update command do?

1050

How can I track the changes or identify the latest insert-update-delete from a table?

912

What is the Control Flow in SSIS

1030