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?
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
define sql insert statement ? : Sql dba
What is procedure explain with example?
what is a control file ? : Sql dba
what does myisamchk do? : Sql dba
What is normalization sql?
Is nosql faster than sql?
How does left join work in sql?
How many types of index are there?
What is the purpose of cursors in pl/sql?
What is sql dialect?
What is not in sql?
What is a full join?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What is a recursive stored procedure?
What are the types of variable use in pl sql?