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
- 51694 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / naresh
select * from emp where sal in(select sal from emp group by
sal having count(sal)>1);
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Is left join same as join?
What is sql performance tuning?
What is group by in sql?
What is flag in sql?
Why partition by is used in sql?
What does rownum mean in sql?
Is sql a case sensitive language?
Is sql free?
What is where clause in sql?
What does (*) mean in sql?
What is an index in sql with example?
What is indexes?
How does join work in sql?
How are functions and procedures called in PL/SQL?
How do I run a pl sql procedure in sql developer?
