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

In what version of sql server were synonyms released?

1001

What is a data collection table?

1051

What is bulkcopy in sql?

1000

What are cursors and when they are useful?

1153

What is the dbcc command and why is it used?

1109

What is auditing in sql server?

969

How to Check if table exists in sql server?

1189

What is a trace frag?

1136

Explain about SQLOS?

1061

Can a table be moved to different filegroup?

1026

What are SSL and TSL protocols?

1035

What stored by the msdb?

1048

Define Business Edition in SQL Azure?

102

Explain triggers?

1066

Can we linked SharePoint to a SQL database?

1078