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

Can we create table inside stored procedure?

950

What is case function?

1037

What are the possible values for the boolean data field?

961

Describe sql comments?

1033

What are the three pl sql block types?

1006

What are the advantages of pl sql over sql?

1024

Does sql use python?

1024

How many indexes can be created on a table in sql?

1052

What are all the different types of indexes?

1147

What is update query?

977

what is bdb (berkeleydb)? : Sql dba

1030

How do you identify a primary key?

1062

What is the primary use of normalization?

1001

What schema means?

887

What are tables and fields in the database?

1107