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 / 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
How global cursor can be declare with dynamic trigger ?
What do you mean by table in sql?
what are integrity rules?
Is natural join and inner join same?
Which type of cursor is used to execute the dml statement?
What is a natural join?
What is pl sql script?
How many joins can you have in sql?
Explain about various levels of constraint.
Is it possible to create the following trigger: before or after update trigger for each row?
what is foreign key? : Sql dba
Can %notfound return null after a fetch?
how to rename an existing column in a table? : Sql dba
Explain the working of primary key?
Which one is better sql or oracle?