Answer Posted / nirmalendu

delete from table_name where rowid not in(select min(rowid)
from table_name group by column_name);

** column_name which having duplicate record

What is faster join or subquery?

968

---

What are the parameter modes supported by pl/sql?

1031

---

What is serial sql?

929

---

what is isam? : Sql dba

960

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

906

---

Can we use update in sql function?

1016

---

What are the features of pl sql?

1020

---

what is sp_pkeys? : Transact sql

1116

---

What is nosql vs sql?

1128

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

997

---

Which is better trigger or stored procedure?

900

---

What are % type and % rowtype?

990

---

Can a procedure in a package be overloaded?

995

---

What is group by in sql?

1038

---

how to include numeric values in sql statements? : Sql dba

1052

---