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
23656 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 the largest value that can be stored in a byte data field?

1012

Which type of cursor is used to execute the dml statement?

952

Can you join a table to itself?

1122

What are packages in pl sql and also explain its advantages?

1027

How do you modify a table in sql?

1118

What is the use of primary key?

1005

What are hotfixes and patches?

942

what is difference between delete and truncate commands? : Sql dba

1126

explain commit and rollback in mysql : sql dba

1009

What is procedure explain with program?

1015

Write the command to remove all players named sachin from the players table.

1180

What is a trigger in sql?

1200

When sql appeared?

1087

Explain what is an index?

1053

Is natural join and inner join same?

919