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
50665 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 can we optimize a sql query?

982

What is dbo in sql?

918

What is data type in database?

927

How can you load multi line records? : aql loader

1019

What types of commands can be executed in sql*plus?

1048

Can a composite key be null?

905

What is the maximum size of sqlite database?

1039

when is the use of update_statistics command? : Sql dba

967

What is input buffer in sql*plus?

1122

What are the types of keys?

925

What kind of join is join?

903

What are triggers and its types?

992

Which is better stored procedure or query?

918

What is the use of sqlerrd 3?

889

What does select count (*) mean in sql?

959