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 / a.brahmam
delete from table name
where rowid not in(select max(rowid) from table name group by column name)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can the query output be sorted by multiple columns in oracle?
Explain the use of online redo log files in oracle.
What is procedure overloading in oracle?
What are named parameters?
How to rename an index?
What is rowid and rownum in oracle?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
Can we connect to ORACLE db using Windows Authentication?
Does facebook use oracle?
Explain an extent?
What is merge in oracle?
How to check database size in Oracle?
What is recovery manager(rman) backup in Oracle?
how to join query for one source type is oracle another source type is sql server ?
What is a trigger and what are its types in oracle?