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

How do I find information about the install locations for the various instances running on a computer?

1126

Explain different types of lock modes in sql server 2000?

985

Explain mixed authentication mode of sql server?

1121

Explain sql server authentication modes?

1189

What is transaction server explicit transaction?

1089

How do I create a stored procedure in dbml?

1084

What is meant by referential integrity?

1049

Differentiate between a having clause and a where clause.

1010

What is difference between commit and rollback when used in transactions?

1019

How do I find my localdb version?

1031

Other than truncate statement, which other command can by-pass the trigger on the tables?

1193

How do you run a trace?

947

Tell me what are cursors and when they are useful?

995

can you instantiate a com object by using t-sql? : Sql server database administration

1044

How can a database be repaired?

1034