Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used
- 11 Answers
- 19164 Views
- UST, I also Faced
- E-Mail Answers
Answer Posted / jas
delete from table_name where rowid > (select min(rowid)
from table_name where a.col_name=b.col_name)
create new_table as select distinct * from table_name;
drop table_name;
create table_name as select * from new_table;
drop new_table;
delete from table_name where rowid not in (select max
(rowid) from table_name where a.col_name=b.col_name)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the use of sqldataadapter?
What is the difference between count 1 and count (*) in a sql query?
what is uncommittable transactions? : Transact sql
Which is better join or subquery?
What is the purpose of normalization?
How does rowid help in running a query faster?
How can I get the number of records affected by a stored procedure?
What are the two parts of design view?
Is natural join same as inner join?
How to raise user-defined exception with custom sqlerrm ?
what is column? : Sql dba
What do you understand by pl/sql cursors?
Can we join two tables without common column?
Can we connect to postgresql using sql developer?
What is the difference between local and global temporary table?
