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
24027 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

When to use inner join and left join?

1019

What are all the common sql functions?

1084

State some properties of relational databases?

1115

Why do we use partitions in sql?

1096

Which join is default?

1016

What is record in pl sql?

1140

What is difference between joins and union?

1196

what is clause? : Sql dba

1118

what is normalization? : Sql dba

1137

What are data types in pl sql?

1199

Explain locks? : Transact sql

1058

What are the ddl commands?

1055

What is the use of sqldataadapter?

1026

How to pronounce postgresql?

1098

What is sql used for?

1166