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

What is the difference between microsoft sql and mysql?

959

Does postgresql run on the cloud?

1143

what is cross join? : Sql dba

994

Why indexing is needed?

981

What are all the common sql functions?

1014

What is an implicit commit?

1049

How do I pipe the output of one isql to another?

1003

What are the operators in sql?

1025

What is sql resultset?

982

What is trigger and types?

1023

Why cross join is used?

1074

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1225

What is your daily office routine?

2266

What is mutating error?

964

How to create a menu in sqlplus or pl/sql?

1120