select * from education where rowid in (select min(rowid) from ex group b

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?

Question Posted / a.balakrishna

29 Answers
50721 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

Please Help Members By Posting Answers For Below Questions

Explain what is sql*plus?

1087

What is the max nvarchar size?

899

How we can update the view?

1007

What is sql analyzer?

962

how tsql statements can be written and submitted to the database engine? : Transact sql

924

What are the different types of a subquery?

983

What is a table partition?

1038

Can a table contain multiple primary key’s?

1045

What is a common use of group by in sql?

997

how to delete an existing column in a table? : Sql dba

954

Is primary key clustered or nonclustered?

954

Is sql workbench free?

932

Can 2 queries be executed simultaneously in a distributed database system?

1084

what is the functionality of the function htmlentities? : Sql dba

894

what is oltp (online transaction processing)? : Sql dba

1016