In the above query we have to add distinct before *. Else duplicate rows

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 / lakshmi

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

Answer Posted / lakshmi

In the above query we have to add distinct before *. Else
duplicate rows will be fetched twice.

Thanks,
Lakshmi

Is This Answer Correct ?

9 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are analytical functions in sql?

1078

Can we use ddl commands in pl sql?

1234

Explain the difference between triggers and constraints?

1025

what is 'trigger' in sql? : Sql dba

1145

Can %notfound return null after a fetch?

1102

What packages(if any) has oracle provided for use by developers?

5883

In a distributed database system, can we execute two queries simultaneously?

1155

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1176

What are the differences between implicit and explicit cursors?

1109

Why do we use procedures in sql?

1141

explain primary keys and auto increment fields in mysql : sql dba

1017

What is the use of desc in sql?

1022

what are date and time intervals? : Sql dba

1105

Does oracle use sql?

992

Is clustered index a primary key?

987