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?
- 28 Answers
- 43984 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / a.balakrishna
select * from education where rowid in (select min(rowid)
from ex group by sno having count(*)>1);
100% it is true
Best of luck
9177509010
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Differentiate between % rowtype and type record.
what are local and global variables and their differences? : Sql dba
What is pl sql block in dbms?
What are the different types of sql commands?
List different type of expressions with the example.
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
How exception is different from error?
What does the hierarchical profiler does?
What is scalar function?
what are the join types in tsql? : Transact sql
which types of join is used in sql widely? : Sql dba
Is sql procedural language?
What are the different types of a subquery?
What do you know by pl/sql cursors?
what are set operators in sql? : Sql dba
