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;

Is sql a backend language?

1100

---

How do you add a column to a table?

1062

---

Is drop table faster than truncate?

997

---

How to display Row Number with Records in Oracle SQL Plus?

1051

---

what is a database transaction? : Sql dba

1190

---

Difference between table function and pipelined function?

1029

---

What is a string data type in sql?

1048

---

Why trigger is used in sql?

977

---

What is the sql query to display the current date?

1048

---

Is left join faster than inner join?

1130

---

how to use regular expression in pattern match conditions? : Sql dba

1040

---

What is the use of double ampersand (&&) in sql queries? Give an example

1143

---

how to extract a unit value from a date and time? : Sql dba

998

---

How do I use google cloud in sql?

1095

---

Can we use ddl commands in pl sql?

1166

---