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

What is the least restrictive isolation level? : Transact sql

0 Answers  

---

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

0 Answers  

---

What is union, minus and interact commands?

0 Answers  

---

what is the sql query to display current date? : Sql dba

1 Answers  

---

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

---

What is package in pl sql with an examples?

0 Answers  

---

What is the use of prepared statement?

0 Answers  

---

Can we update views in sql?

0 Answers  

---

I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 Answers  

---

create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers   Polaris,

---

Can we commit inside a trigger?

0 Answers  

---

Explain what is a view?

0 Answers  

---