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
What are database links used for?
What is group function in sql?
what is a control file ? : Sql dba
what is dbms? : Sql dba
What does joining a thread mean?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
What is sql engine in oracle?
What are predefined functions in sql?
Does postgresql run on the cloud?
How do I pipe the output of one isql to another?
Which normal form is best?
what does the t-sql command ident_incr does? : Transact sql
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...
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
What is the difference between sql, mysql and sql server?