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

What is the disadvantage of User defind function?

2238

Name the three major set of files on disk that compose a database in Oracle?

1062

How to return top 5 rows in oracle?

985

Why packages are used in oracle?

999

How to omit columns with default values in insert statement in oracle?

993

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1870

Please explain joins in oracle?

1007

Why cursor variables are easier to use than cursors?

1019

How to convert a date to char in oracle? Give one example.

1000

What is oracle database client?

973

Does oracle partitioning improve performance?

942

How do I know if oracle client is installed on windows?

950

What is a Garbage Collection? and what is full recursive Garbage collection?

2840

what is the dual table in oracle?

931

What is meant by recursive hints in oracle?

1023