DELETE from <table_name> a where a.rowid

one of the column in my table contains the data like
SAL
----
1000
1000
2000
3000
3000

So my requirement is i want output like
SAL
---
1000
2000
3000

it mean i want to delete duplicate rows in the table
permanently and i want output in the above formatow should u
write query?

Question Posted / sarthak mohanty

13 Answers
23233 Views
Cap Gemini, TCS, I also Faced
E-Mail Answers

Answer Posted / sarthak mohanty

DELETE
from <table_name> a
where a.rowid > ANY(select b.rowid
from <table_name> b
where a.salary=b.salary);

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sql analyzer?

959

what is a foreign key ? : Sql dba

1026

Why should I use postgresql?

971

What mean sql?

951

What is sorting in sql?

893

List and explain the different types of join clauses supported in ansi-standard sql?

1300

Can I call a procedure inside a function?

945

What is sqlca in db2?

890

What is over () in sql?

892

How can we debug in PL/SQL?

1090

How do I upgrade sql?

947

Name some usages of database trigger?

966

What is int identity in sql?

1060

what is foreign key? : Sql dba

969

How do you create an update query?

913