I have table-A(1,2,3,4,4,5,6,6,6,7).
how to get all duplicate values?what is sql query?
- 5 Answers
- 7086 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
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to call a stored function in oracle?
What is a cognitive schema?
State some uses of redo log files?
How to run the anonymous block again?
What are temporal data types in oracle?
what is difference between sql plus and sql*plus? (not sql and sql plus).
Differentiate between function and procedure in oracle.
What to do if the startbd.bat failed to start the xe instance?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
Will you be able to store pictures in the database?explain.
What are the numeric comparison operations?
How does one get the view definition of fixed views/tables?
What do you mean by a database transaction & what all tcl statements are available in oracle?
