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


Please Help Members By Posting Answers For Below Questions

What are database links used for?

796


What is group function in sql?

800


what is a control file ? : Sql dba

802


what is dbms? : Sql dba

769


What does joining a thread mean?

799


How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

1923


What is sql engine in oracle?

769


What are predefined functions in sql?

746


Does postgresql run on the cloud?

844


How do I pipe the output of one isql to another?

753


Which normal form is best?

715


what does the t-sql command ident_incr does? : Transact sql

847


1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

2207


what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

785


What is the difference between sql, mysql and sql server?

737