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
24036 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 benefit of creating memory optimized table?

1034

Why is pl sql needed?

1005

Can we use pl sql in mysql?

1063

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1176

what is the difference between a local and a global temporary table? : Sql dba

1130

what is a database? : Sql dba

1242

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2339

What is primary key and foreign key with example?

984

Can we use ddl commands in pl sql?

1235

What is the usage of sql functions?

1206

What is the difference between clustered and non-clustered indexes?

1132

Explain what is table in a database?

1110

How does postgresql compare to mysql?

1080

How do you create a unique index?

1094

How do I truncate a word?

1163