select count(*),empname from emp group by empname having count(*)>1

How reterive duplicate value in SQL?

Question Posted / rajesh.a

6 Answers
10652 Views
I also Faced
E-Mail Answers

Answer Posted / rajesh.a

select count(*),empname from emp group by empname having count(*)>1

Is This Answer Correct ?

4 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

1004

Define right outer join?

974

Define indexes?

1035

Explain Geography datatype in SQL Server

1118

How to manipulate data from one table to another table ?

963

Explain differences between web edition and business edition?

119

Can I run multiple instances of sql server 2000 at the same time on one computer?

1070

What is the difference between DataRow.Delete() and DataRow.Remove()?

1224

What is the concept of optimization?

1036

Is sql server difficult to learn?

913

How to rebuild master databse?

1073

What are a scheduled jobs or what is a scheduled tasks?

897

What does <> symbol mean?

959

Why we should not use triggers?

961

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

945