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

5 Answers
8604 Views
Zensar, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain enable novalidate constraint.

1094

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1936

Is oracle an operator?

932

Is java required for oracle client?

1004

Explain cascading triggers.

1082

Which is faster join or subquery in oracle?

1000

Why should I use oracle database?

1001

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

2162

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5574

How would you change old and new values in an insert, delete and update triggers?

1027

How to define a sub function?

1141

What happens to the data files if a tablespace is dropped?

1064

What is the difference between alert log file and tarce file ?

2179

what is difference between sql plus and sql*plus? (not sql and sql plus).

3910

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2272