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
51037 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 unique key and primary key and foreign key?

932

Does google use sql?

921

What is exit statement?

967

What is a scalar value in sql?

1026

what is oltp (online transaction processing)? : Sql dba

1034

Is sql difficult?

1119

What pl/sql package consists of?

1045

What is the difference between partition and index?

939

What is Histogram?

1519

What is clustered index in sql?

1018

What is normalization sql?

1012

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

904

how to analyze tables with 'mysqlcheck'? : Sql dba

973

Explain what is sql?

1079

What does (+) mean in sql joins?

1032