SQL>DELETE FROM <TABLE NAME> WHERE ROWID NOT IN (SELECT MIN(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 / amit

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

Answer Posted / amit

SQL>DELETE FROM <TABLE NAME>
WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM <TABLE NAME>
GROUP BY SAL);

Is This Answer Correct ?

9 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is execute immediate?

1081

How do I find duplicates in the same column?

1079

How does sql developer connect to oracle database?

998

tell us something about heap tables. : Sql dba

1096

How sql query is executed?

1127

How to Declare Fixed Length String Value In PL SQL

1153

How to get list of all tables from a database?

1153

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1115

Why stored procedure is better than query?

943

What is self-join and what is the requirement of self-join?

1149

How does cross join work?

947

What is substitution variable in pl sql?

1042

Which is better trigger or stored procedure?

947

What is oracle sql called?

922

Explain architecture of sql server notification services?

1054