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

Explain about functional dependency and its relation with table design?

1010

Explain a synonym?

1029

what is the difference between restoring and recovering?

1011

What are the major difference between truncate and delete?

1058

Where do we use decode and case statements?

1012

Explain an index segment?

1118

Why is oracle used?

938

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2051

Explain the use of tables option in exp command.

1116

how may join possible between (requisition with purchase order)

2250

Why does for update in oracle 8 cause an ora-01002 error?

1003

How to add a new column to an existing table in oracle?

1139

What is a dynamic performance view in oracle?

991

What are the predefined tablespaces in a database?

1081

How to use select statement to count the number of rows in oracle?

1044