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 usage of sql functions?

0 Answers  

---

What are the two types of periodical indexes?

0 Answers  

---

How to run pl/sql statements in sql*plus?

0 Answers  

---

i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#

1 Answers  

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

0 Answers  

---

What are the rules to be applied to nulls whilst doing comparisons?

0 Answers  

---

What is a self join ?

6 Answers   BirlaSoft,

---

Difference between SUBSTR and INSTR?

3 Answers  

---

What is a CTE (Common Table Expression), and how is it different from a subquery?

3 Answers  

---

IF i write before / after insert / update trigger and i do rollback what will happen?

5 Answers   KPIT,

---

What is a primary key called that is made up of more than one field?

0 Answers  

---

What is a dirty read sql?

0 Answers  

---