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
23225 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 maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1063

how to use 'mysql' to run sql statements? : Sql dba

982

Explain the select statement in sql?

1043

Does sql profiler affect performance?

939

what is the difference between a local and a global temporary table? : Sql dba

1003

Does sql*plus have a pl/sql engine?

995

what is sub-query? : Transact sql

1038

What is package in pl sql with an examples?

970

What are the indexing methods?

1001

What is pl sql collection?

919

How can I speed up sql query?

904

What is a primary key example?

901

Why do we use joins?

983

What is a call statement? Explain with an example.

950

What is graph sql?

935