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

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

1015

How to use fetch statement in a loop?

1006

How are extents allocated to a segment?

1104

What are the differences between interval year to month and interval day to second?

1010

How to run queries on external tables?

1022

What is Redo Log Buffer in Oracle?

1183

Describe varray?

1037

various types of hints and their usage

2667

Write a syntax for update query in oracle?

1009

How remove data files before opening a database?

1047

What is the exact use of Collections?

2129

how to join query for one source type is oracle another source type is sql server ?

2406

How to grant create session privilege to a user in oracle?

975

What is primefaces used for?

1034

What is the use of aggregate functions in oracle?

1012