select Emp_Id from Employee 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 / v rajkumar

Answer Posted / v rajkumar

select Emp_Id from Employee group by Emp_Id having count(*)
>1

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to delete a database in ms sql server?

1239

Explain what is log shipping?

1139

Do you know the isolation level that sql server support?

965

What are different types of replication in sql server?

1090

What is the purpose of update statistics and scope_identity() function?

1100

Explain where clause?

992

What is a database in ms sql server?

1062

What is acid db?

889

What is sql server programming?

1046

Explain active/passive and active/active cluster configurations?

1061

What are two difference between sql azure and azure tables?

159

What are the purposes of floor and sign functions?

978

How to use transact-sql statements to access the database engine?

1069

How can we solve concurrency problems?

1057

How do I uninstall sql server 2014?

940