how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used
Answer Posted / raghavendraprasad
delete from table_name where rowid not in (select max
(rowid) from table group by duplicate_values_field_name);
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
when is the use of update_statistics command? : Sql dba
Compare sql & pl/sql
What are the types of dbms?
Why trigger is used in sql?
Can we rollback delete command?
What are sql queries used for?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What trigger means?
What is normalisation and its types?
How do I count rows in sql query?
What is trigger and how to use it in sql?
How many types of literals are available in pl sql?
What are two statement types in sql?
What is AUTH_ID and AUTH_USER in pl/sql ?
What are system versioned tables?