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

Answer / vyshak

delete from table where rowid not in (select max(rowid) from
table group by all column names);

or

delete (dense_rank() over(partition by all column names))dn
from table where dn>2;

Answer / guest

select distinct

How can triggers be used for the table auditing?

0 Answers  

---

Write a query to get 2nd maximum salary in an employee table ?

69 Answers   Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,

---

What does inner join mean?

0 Answers  

---

What is the purpose of a sql?

0 Answers  

---

Where the integrity constrints are stored in Data Dictionary?

1 Answers  

---

Define commit?

0 Answers  

---

Can you skip header records while loading? : aql loader

0 Answers  

---

Does sql full backup truncate logs?

0 Answers  

---

Explain how to use transactions efficiently : transact sql

0 Answers  

---

Does sql*plus also have a pl/sql engine?

0 Answers  

---

What does partition by mean in sql?

0 Answers  

---

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

0 Answers  

---