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
- 7808 Views
- Zensar, I also Faced
- E-Mail Answers
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
How to view existing locks on the database?
In oracle there is column command, how will you explain that?
what happened to the global index when I truncate the data in one of the partition?
Explain the dml?
query optmization techniques and quwry analyser+projects+ppts
Is truncate autocommit in oracle?
What is define in oracle?
What is oracle used for?
What is execute immediate in oracle?
How to display employee records who gets more salary than the average salary in the department?
Is oracle the best database?
What are oracle functions?
What are the execution control statements?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is null value in oracle?
