I have table-A(1,2,3,4,4,5,6,6,6,7).
how to get all duplicate values?what is sql query?
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
Explain enable novalidate constraint.
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
Is oracle an operator?
Is java required for oracle client?
Explain cascading triggers.
Which is faster join or subquery in oracle?
Why should I use oracle database?
How can we create the complete backup of data in the oracle.
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.
How would you change old and new values in an insert, delete and update triggers?
How to define a sub function?
What happens to the data files if a tablespace is dropped?
What is the difference between alert log file and tarce file ?
what is difference between sql plus and sql*plus? (not sql and sql plus).
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?