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

What is a join?

1054

---

Write a query to display the current date in sql?

1014

---

What is pl sql in oracle?

1037

---

What are the main features of cursor?

1071

---

Does a primary key have to be a number?

960

---

What does select * from mean in sql?

3205

---

Explain normalization and what are the advantages of it?

947

---

Is sqlite free?

960

---

how to get help information from the server? : Sql dba

931

---

What language is oracle sql developer?

991

---

Can you skip header records while loading? : aql loader

1039

---

what is a composite key ? : Sql dba

1043

---

How do you take the union of two tables in sql?

977

---

Write a query to find the names of users that begin with "um" in sql?

982

---

what are the types of join and explain each? : Sql dba

1028

---