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
- 50669 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
How do you declare a variable in pl sql?
How can get second highest salary in sql?
What can I use instead of union in sql?
How does a covering index work?
What is difference between procedure and trigger?
Can we use two order by clause in query?
Can sql developer connect to db2?
What is sql and explain its components?
What is the difference between nested table and varray?
State some properties of relational databases?
Can function return multiple values in sql?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
How many types of tables are there?
what is the difference between a having clause and a where clause? : Sql dba
What are pl/sql packages?
