create table salary2 as select distinct * from salary1 drop table salary1

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 / destiny

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

Answer Posted / destiny

create table salary2 as select distinct * from salary1
drop table salary1
rename salary2 to salary1

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 use delete in merge statement?

999

Is sql sequential or random?

980

What will you get by the cursor attribute sql%rowcount?

970

What is sql indexing?

963

how to get help information from the server? : Sql dba

874

How many clustered indexes can be created on a table?

1022

How do I view tables in mysql?

914

What are the different types of sql commands?

1061

What is crud stand for?

930

What is raw datatype in sql?

979

how many tables will create when we create table, what are they? : Sql dba

1018

What is full join in sql?

937

What does where 1 1 mean in sql?

978

How can you select unique records from a table?

991

Mention what are the benefits of pl/sql packages?

999