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 can you tell if a database object is invalid?

1012

How can you insert values in multiple rows using one Insert statement?

1034

Can we create clustered index on composite key?

978

How to select some specific rows from a table in ms sql server?

960

What is a recursive stored procedure in sql server?

1085

How to use old values to define new values in update statements in ms sql server?

1163

What is save transaction and save point?

1119

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

971

Can you explain the disadvantages/limitation of the cursor?

905

What is a raid and what are different types of raid configurations?

1200

what is a sub-report?

132

What is the data tier application?

169

What is database mirroring?

1037

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

932

Mention a few common trace flags used with sql server?

879