SELECT COUNT(EMPNO),ENAME FROM EDUCTION GROUP BY ENAME;

How to retrieve Duplicate Rows only in a Table?
Suppose if a Table Name is "Education". It consists of
multiple columns. Then if we insert rows into this table
with duplicate records then how can we retrieve only
duplicate records from that table?

Question Posted / dawood

29 Answers
51631 Views
Alps, Aricent, Bank Of America, Wipro, I also Faced
E-Mail Answers

Answer Posted / dawood

SELECT COUNT(EMPNO),ENAME FROM EDUCTION
GROUP BY ENAME;

Is This Answer Correct ?

5 Yes

10 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a record in pl/sql?

1135

Explain the steps needed to create the scheduled job?

1033

How do you update a sql procedure?

1019

Which normal form is best?

946

Is keyword pl sql?

971

What is the purpose of design view?

1001

List the various privileges that a user can grant to another user?

1036

what are the advantages of sql ? : Sql dba

1052

what are the different tables present in mysql? : Sql dba

972

What is application trigger?

985

How do you define a foreign key?

988

What is trigger in pl sql?

988

what is the difference between cluster and non cluster index? : Sql dba

1015

What is a procedure in pl sql?

1203

How do I clear the screen in sql plus?

1035