delete from table_name alias1 where rownum

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 / dinesh kumar

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

Answer Posted / dinesh kumar

delete from table_name alias1
where rownum < ( select max(rownum) from table_name alias2
where alias1.col1 = alias.col2 );

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is nosql db?

966

What is indexes?

1056

explain advantages of myisam over innodb? : Sql dba

1069

What is a pragma statement?

1262

What is the use of double ampersand (&&) in sql queries? Give an example

1139

Where is all the data on the internet stored?

1009

Is sqlexception checked or unchecked?

968

How many sql databases can you have on one server?

1081

What is cursor explain with example?

984

explain the difference between bool, tinyint and bit. : Sql dba

997

What is pl sql quora?

1155

Are pl sql variables case sensitive?

1045

What is the best sql course?

983

What is cartesian join in sql?

1128

what is union, minus and interact commands? : Sql dba

1185