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

Define SQL and state the differences between SQL and other conventional programming Languages?

1138

Does pdo prevent sql injection?

880

how to select first 5 records from a table? : Sql dba

918

explain the difference between myisam static and myisam dynamic. : Sql dba

884

How do I view tables in mysql?

912

what is the difference between blob and text? : Sql dba

960

what is the difference between a local and a global temporary table? : Sql dba

1003

What is sql data?

922

What is the basic structure of an sql?

1031

What is forward declaration in pl sql?

1005

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

1038

Is trigger a stored procedure?

884

What is a sql trace file?

973

how to return query output in html format? : Sql dba

1018

What is ttitle and btitle?

1006