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 / 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
What are the types of subqueries?
Define SQL and state the differences between SQL and other conventional programming Languages?
Explain what is dbms?
What is the difference between between and in condition operators?
What is function and procedure?
Is oracle sql free?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
Can we use pl sql in mysql?
What is a record in a database?
What do you understand by pl/sql packages?
What is assignment operator in pl sql?
Does normalization improve performance?
What is difference between primary and secondary key?
What is a trigger word?
How do I find duplicates in a single column in sql?