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
24033 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 does an inner join do?

1248

What is the difference between left join and right join?

990

what is not null constraint? : Sql dba

1078

How to convert comma separated string to array in pl/sql?

1242

Is delete faster than truncate?

1052

When is a declare statement required?

1197

How many joins in sql?

1059

How does sql store data?

959

What is a string data type in sql?

1102

What is difference between pl and sql?

1111

What is the use of partition by in sql?

1047

What is character functions?

1116

How to return multiple rows from the stored procedure?

1016

Is pl sql useful?

1038

What is rank dense_rank and partition in sql?

1087