Answer Posted / santosh kumar

simple answer for deleting duplicate record from a table.....
table:---
create table t1 (id number(5),name varchar2(20));

then:----
insert into t1 values(10,'a');
insert into t1 values(10,'a');
insert into t1 values(20,'b');
insert into t1 values(20,'b');
---after insertion it'll like this----
id name
10 a
10 a
20 b
20 b

-------------------------------------------------------------
delete from t1
where rowid not in (select min(rowid) from t1 group by name);

What is oracle and pl sql?

1107

---

How can the performance of a trigger be improved?

1022

---

How would you reference column values before and after you have inserted and deleted triggers?

1050

---

How do you rank data in sql?

983

---

What is pl/sql table? Why is it used?

1014

---

What is a schema? How is it useful in sql servers?

1096

---

Why is the cursor important?

1023

---

Who developed sql?

1019

---

Does a user_objects view have an entry for a trigger?

1001

---

Can you upgrade sql express to full sql?

1044

---

what are the differences between char and nchar? : Sql dba

1097

---

How do I order columns in sql?

967

---

Is mariadb nosql?

1030

---

Which sql most popular?

975

---

How many rows can sqlite handle?

1092

---