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 are the execution control statements in oracle?

1133

What are the different oracle database objects?

1150

what is normalisation?what are its uses?

2334

What is an oracle table?

1034

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

1067

What is a tns service name?

1058

What is a initialization parameter file in oracle?

1087

What is data block in Oracle?

1151

Explain the function of optimizer in oracle?

1202

What is Java Pool in Oracle?

1249

What is a sub query? Describe its types?

1074

What are the various constraints used in oracle?

1098

What is oracle database 10g express edition?

1172

What is a subquery in oracle?

1168

How to create a new user account in oracle?

1065