Answer Posted / korimantu

delete from table name where rowid not in(select max(rowid)
from group by last_name);

or

delete from table name where rowid>(select min(rowid) from
where a.last_name=b.last_name);

What is null in pl/sql?

625

---

How can one get sql*loader to commit only at the end of the load file? : aql loader

568

---

What are data types in pl sql?

563

---

What is a pragma statement?

720

---

How many joins in sql?

554

---

---

How to Execute a Package in PL/SQL.?

585

---

what is msql? : Sql dba

564

---

What does the base_object_type column shows in the user.triggers data dictionary view?

574

---

What is primary and foreign key?

592

---

what are the 'mysql' command line arguments? : Sql dba

650

---

What is a recursive stored procedure?

617

---

How can check sql version from command line?

535

---

What are tables in sql?

548

---

Can a select statement fire a trigger?

658

---

What is a left join?

510

---