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 difference between sql and t-sql? : Transact sql

0 Answers  

---

Explain isolation levels. : Transact sql

0 Answers  

---

What is sql*loader?

0 Answers  

---

what is the cursor and use of cursor in pl/sql ?

4 Answers  

---

What does sign mean sql?

0 Answers  

---

what is a foreign key ? : Sql dba

0 Answers  

---

What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.

5 Answers   Polaris,

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

What is a variable in sql?

0 Answers  

---

What is Raise_application_error ?

1 Answers  

---

What is a database trigger?

0 Answers  

---

how can i read files from a pl/sq l program

3 Answers  

---