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?
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
how to convert dates to character strings? : Sql dba
How do I count duplicates in sql?
How to run sql statements through the web interface?
What is data abstraction in sql?
Is sql considered coding?
What does select top 1 do in sql?
Is left join and outer join same?
How do I run sql profiler?
What is a sql select statement?
Explain how can you save or place your msg in a table?
What is the purpose of the sql select top clause?
What is the difference between in and between in sql?
What is the use of %rowtype?
give the syntax of grant and revoke commands? : Sql dba
Define commit, rollback and savepoint?