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)

what is difference between delete and truncate commands? : Sql dba

1133

---

What is sql dialect?

1120

---

Can we enter data in a table in design view?

969

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

972

---

What are the types of dbms?

975

---

How to pipe multiline string to isql?

1007

---

What is the difference between microsoft sql and mysql?

962

---

Define sql delete statement.

1016

---

Is sql an operating system?

1020

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1063

---

What are the key differences between SQL and PL SQL?

1215

---

can sql servers linked to other servers like oracle? : Sql dba

1009

---

What is full form of rtm?

1008

---

What is the purpose of normalization?

1042

---

how to analyze tables with 'mysqlcheck'? : Sql dba

1013

---