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
23721 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 range partitioning?

972

What are the two virtual tables available at the time of database trigger execution?

1223

How to start oracle sql developer?

1040

What is error ora-01000: maximum open cursors exceeded

1147

What are analytic functions in sql?

1030

What are the types of functions in sql?

1021

What is Histogram?

1564

What is a sql trace file?

1034

What is sql procedures and functions?

1012

describe transaction-safe table types in mysql : sql dba

1007

Explain what is a field in a database and record in a database?

1097

What does dml mean?

993

What are the types of join in sql?

1103

Which language is used in sql?

1064

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1039