how to delete all duplicate records from a table using
subquery?
Answer Posted / maninder
delete from abc where rowid not in (select max(rowid) from
abc group by column_name_with_dup.values.);
Is This Answer Correct ? | 10 Yes | 6 No |
Post New Answer View All Answers
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Where do you use decode and case statements?
How to lock and unlock a user account in oracle?
What are oracle functions?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How can Oracle users be audited?
Hi Can any one tell me what are the API's used in requisition import.
Explain an index?
How to specify default values in insert statement using oracle?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
How to use "while" statements in oracle?
Which are the five query types available in oracle?
What suggestions do you have to reduce the network traffic?
Differentiate between pre-select and pre-query?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.