SQL> DELETE FROM <TABLE_NAME> WHERE (ROWID,SAL) NOT IN

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 / guest

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

Answer Posted / guest

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

Is This Answer Correct ?

13 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can variables be used in sql statements?

1037

What is the difference between distinct and unique in sql?

956

What is difference between hql and native sql?

1177

Explain foreign key in sql?

1039

What is %type in sql?

971

Can two tables have same primary key?

982

What does the base_object_type column shows in the user.triggers data dictionary view?

1056

How to return multiple rows from the stored procedure?

974

What is an exception in pl/sql?

1094

What are %type and %rowtype for?

1056

Which is better join or subquery?

1143

How can I delete duplicate rows?

1022

Explain what is table in a database?

1065

Why we use pl sql?

963

What is using in sql?

1098