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 are different types of keys?

0 Answers  

---

What is a stored procedure ?

9 Answers  

---

What is inner join in sql?

0 Answers  

---

What is attribute indicator in pl sql?

0 Answers  

---

What does the argument [or replace] do?

0 Answers  

---

How to revise and re-run the last sql command?

0 Answers  

---

What are the advantages of VIEW?

5 Answers  

---

what does it mean to have quoted_identifier on? : Sql dba

0 Answers  

---

How many types of sql are there?

0 Answers  

---

how to select first 5 records from a table? : Sql dba

0 Answers  

---

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

---