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
- 51822 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
What is java sql package?
What does plv msg allows you to do?
How do you write an inner join query?
What are the various levels of constraints?
What is insert command in sql?
What are schema-level triggers?
What is dml statement?
What is flag in sql?
What is string join?
How can you create an empty table from an existing table?
What is error ora-12154: tns:could not resolve the connect identifier specified?
who introduced sql?
How many types of literals are available in pl sql?
What is embedded sql in db2?
What are variables in pl sql?
