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
- 51691 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / lakshmi narayana
select * from emp a ,
(select empno,count(*) from emp group by empno having count
(*) > 1) b
where a.empno = b.empno
| Is This Answer Correct ? | 27 Yes | 10 No |
Post New Answer View All Answers
How show all rows in sql?
Is it possible to link two groups inside a cross products after the cross products group has been created?
What is sql keyword?
Can we create view in stored procedure?
what is bcp? When does it used? : Sql dba
What is the process of debugging?
Define commit, rollback and savepoint?
What is over () in sql?
Is mariadb nosql?
What are the differences between implicit and explicit cursors?
How do I partition a table in sql?
How to sort the rows in sql.
What are the two different parts of the pl/sql packages?
Inline the values in PL/SQL, what does it mean.?
What does sign mean sql?
