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
23670 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

How many types of index are there?

1033

What are the rules to be applied to nulls whilst doing comparisons?

1323

Can sql developer connect to db2?

1038

Which command is used to call a stored procedure?

999

Write a sql select query that only returns each name only once from a table?

1011

What is oracle pl sql developer?

978

What is oracle sql called?

922

When can we use the where clause and the having clause?

1016

Can a select statement fire a trigger?

1154

How to change sql*plus system settings?

1051

Is it possible to create startup or shutdown trigger for on-schema?

1021

Which is faster joins or subqueries?

987

explain normalization concept? : Sql dba

1045

Explain cursor types?

1019

Explain the update statement in sql

983