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?
- 13 Answers
- 19854 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
What is your daily office routine?
Why do we need view in sql?
What are the steps for performance tuning.
How do you break a loop in pl sql?
What are the sql versions?
How do I view a table in sql?
How we can update the view?
What is difference between hql and sql?
Which command is used to delete a package?
What is sql data?
How do I upgrade sql?
Mention what are different methods to trace the pl/sql code?
How do I audit the sql sent to the server?
Can we use join in subquery?
What are the types of variables use in pl sql?
