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);

How does cross join work in sql?

955

---

What are inner and outer joins examples of both?

878

---

Explain about various levels of constraint.

880

---

How do I kill a query in postgresql?

1010

---

Can you select everything, but 1 or 2 fields, without writer's cramp?

930

---

What is the use of double ampersand (&&) in sql queries? Give an example

1076

---

Is nosql relational?

890

---

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

964

---

Explain the select statement in sql?

1043

---

What is the use of prepared statement?

951

---

What is sql not null constraint?

980

---

How delete all records from table in sql?

927

---

how can we repair a mysql table? : Sql dba

911

---

Why are indexes and views important to an organization?

897

---

What does truncate mean in sql?

961

---