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

Does group by remove duplicates?

1045

What do you mean by table in sql?

991

What is the unique index?

1054

What do you mean by stored procedures?

1014

Explian rowid, rownum? What are the psoducolumns we have?

1001

Why do we use cursors?

990

How many types of functions are there in sql?

955

What is query execution plan in sql?

1189

What is sql*loader?

1192

How do I install microsoft sql?

1053

Does oracle roll back the transaction on an error?

1014

how to use regular expression in pattern match conditions? : Sql dba

1032

explain the difference between delete , truncate and drop commands? : Sql dba

1094

What is dba in sql? : SQL DBA

1044

What is difference between ms sql and mysql?

964