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
- 50860 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
Why do we need cursor in pl sql?
What is pl/sql language case sensitive?
What are dml commands?
Is left join and outer join same?
Why do we need a foreign key?
What is the difference between between and in condition operators?
What are the different types of tables in sql?
What is a ddl command?
what are the advantages and disadvantages of views in a database? : Sql dba
Can I create table without primary key?
How do I make my sql query run faster?
What is an implicit commit?
Is sql a backend language?
What are the steps for performance tuning.
what is the difference between sql and t-sql? : Transact sql
