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
23724 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 the difference between microsoft access and sql server?

1064

What is bind variable in pl sql?

1057

What is rtm stands for?

1102

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1150

What is pls_integer in pl sql?

1108

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

984

What is sap sql anywhere?

1084

What does (*) mean in sql?

955

What is sql query limit?

982

How is data stored in sql?

1063

What is sap sql?

988

define sql insert statement ? : Sql dba

1033

what are the advantages and disadvantages of views in a database? : Sql dba

1043

What is the maximum database size for sql express?

1030

What are the different types of constraints?

1188