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 cursor in pl sql?

567

---

How do I count rows in sql?

551

---

Why is a primary key important?

537

---

what is a composite key ? : Sql dba

588

---

What are predefined functions in sql?

525

---

---

Does a primary key have to be a number?

512

---

How do you delete duplicates in sql query using rowid?

531

---

How do you pronounce sql?

540

---

Is inner join faster than left join?

623

---

Can we use ddl commands in pl sql?

552

---

What is the difference between subquery and correlated query?

522

---

What is nvarchar max in sql?

572

---

What is memory optimized table?

569

---

How does stored procedure reduce network traffic?

533

---

What are three advantages to using sql?

542

---