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?
- 28 Answers
- 47260 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
Is primary key always clustered index?
What is primary key in db?
How does one use sql*loader to load images, sound clips and documents? : aql loader
What is the purpose of the primary key?
Name the operator which is used in the query for pattern matching?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
How to write html code in pl sql?
What is the use of <> sql?
What is dbo in sql?
What are inner outer left and right joins in sql?
what is the syntax for using sql_variant_property? : Transact sql
What is indexes?
How do you create a db file?
What is index example?
what is heap table? : Sql dba
