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
23379 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 the difference between execution of triggers and stored procedures?

1075

What is difference between nchar and nvarchar?

977

What is a sql schema used for?

1060

How do I view a table in sql?

979

Explain the components of sql?

1012

How many types of triggers are there in pl sql?

1032

Which language is used in sql?

1012

what is a record in a database ? : Sql dba

1026

What are the types of functions in sql?

981

How do you truncate?

869

What is an exception in pl/sql?

1025

What is interval partition?

1021

What is dml and ddl?

914

Mention what pl/sql package consists of?

956

What is a full join?

928