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

3 Answers
7867 Views
iFlex, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a livelock?

966

Is sql different from sql server?

1086

Can you explain powershell included in sql server 2008?

939

What is resource governor in sql server?

995

What are the advantages dts has over bcp?

1000

Why do we use trigger?

971

Is ssrs support other database except ms sql server?

139

What is indexed view?

980

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1146

What are drilldown reports?

154

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

1040

How to change the name of a database user?

960

How do you make a trace?

1024

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1055

List some case manipulation functions in sql?

1027