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 sql engine in oracle?

989

---

What is varchar used for?

1082

---

How is a PL/SQL code compiled?

1230

---

what is meant by urlencode and urldocode? : Sql dba

1176

---

Can we alter stored procedure?

987

---

How can you select unique records from a table?

1077

---

What is clause in sql?

1108

---

what are myisam tables? : Sql dba

1032

---

What is range partitioning?

965

---

Differentiate between % rowtype and type record.

1303

---

What is using in sql?

1091

---

What is having clause in sql?

963

---

Where the sql database files are stored?

1014

---

what is query cache in mysql? : Sql dba

1036

---

What is a recursive stored procedure?

1183

---