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
23360 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 are the features and advantages of object-oriented programming? : Sql dba

974

How do I use google cloud in sql?

1053

What are the possible values that can be stored in a boolean data field?

963

what is a relationship and what are they? : Sql dba

1055

Can we alter stored procedure?

953

What is difference between my sql and sql?

1019

Does truncate release storage space?

1035

what is the command line end user interface - mysql? : Sql dba

941

What does subquery mean in sql?

1012

How to Declare Fixed Length String Value In PL SQL

1119

explain commit and rollback in mysql : sql dba

959

How to make a copy values from one column to another in sql?

1003

What is the difference between partition and index?

944

What is the difference between left and left outer join?

910

How to connect a sql*plus session to an oracle server?

1092