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
52631 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

How to download oracle sql developer?

1167

What is the syntax to add a record to a table?

1151

What is pl sql package?

1071

What are the two virtual tables available at the time of database trigger execution?

1272

What are the sql commands?

1230

What is composite data type in pl sql?

1170

Can we create table in function?

1021

How do you optimize a stored procedure query?

1043

What are all the different normalization?

1084

what is collation? : Sql dba

1205

What is a crud api?

992

Can we commit inside a trigger?

1047

What are triggers and its uses?

1095

What is offset and limit in sql?

1105

Explian rowid, rownum?

1085