select * from a where rowid not in (select min(rowid) from a group by no)

I have table-A(1,2,3,4,4,5,6,6,6,7).
how to get all duplicate values?what is sql query?

Question Posted / vikas

Answer Posted / vikas

select *
from a
where rowid not in (select min(rowid) from a group by no)

no is column in table a;

Is This Answer Correct ?

10 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to use "for" statements in oracle?

1120

How would you go about verifying the network name that the local_listener is currently using?

2105

What happens in oracle commit?

1077

How to loop through a cursor variable?

1124

What are the various constraints used in oracle?

1093

Explain the blob datatype?

1122

What are the varoius components of physical database structure of oracle database?

1037

What is a select query statement in oracle?

1025

How can we create the complete backup of data in the oracle.

2199

How can you merge two tables in oracle?

1046

How would you begin to troubleshoot an ORA-3113 error?

2122

How to manage transaction isolation level?

1054

What is a oracle database?

1105

What is java oracle used for?

1075

How to create a server parameter file?

1183