Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 29 Answers
- 51832 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / aravind
select SPAN_UUID, SPAN_UNIT_UUID, count(*) from
SPAN_SPAN_UNIT group by SPAN_UUID, SPAN_UNIT_UUID having
count(*) > 1;
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is meant by truncate in sql?
Can we use loop in sql?
What is embedded sql what are its advantages?
In what condition is it good to disable a trigger?
What does select count (*) mean in sql?
What are the different type of joins in sql?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What are pl/sql cursor exceptions?
Is sql procedural language?
Explain the steps needed to create the scheduled job?
What is dml statement?
How many sql commands are there?
How does postgresql compare to oracle/db2/ms sql server/informix?
tell us something about heap tables. : Sql dba
What is %type in sql?
