DELETE FROM TABLENAME WHERE ROWID NOT IN( SELECT MAX(

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 / bibhudatta panda

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

Answer Posted / bibhudatta panda

DELETE FROM TABLENAME
WHERE ROWID NOT IN(
SELECT MAX(ROWID)
FROM TABLENAME
GROUP BY Sal
)

Is This Answer Correct ?

4 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is primary key sql?

1046

What is varchar used for?

1086

What are the events on which a database trigger can be based?

1195

Is sql port 1433 encrypted?

1031

What is pl sql script?

1036

What are the two characteristics of a primary key?

987

Can we debug stored procedure?

1031

What is a composite primary key?

1099

Can we call stored procedure in function?

965

what are date and time functions in mysql? : Sql dba

982

what is clause? : Sql dba

1066

What has stored procedures in sql?

1070

What programs use sql?

1017

What is pl sql and why it is used for?

1114

How many developers work on postgresql?

988