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
- 21703 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
Answer Posted / suneelkumar
delete from emp x where rowid>(select rowid from emp y where
x.sal=y.sal)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is csv? : Sql dba
How to know the last executed procedure?
What is the need of merge statement?
how to convert character strings to dates? : Sql dba
How does postgresql compare to mysql?
How can you tell the difference between an index and a view?
What is the difference between sql and mysql?
Can we rollback truncate?
Does oracle roll back the transaction on an error?
Explain ddl statements in pl/sql?
Explain the the update statement in sql?
Is a view faster than a stored procedure?
What is the difference between a database and a relational database?
What are tables and fields?
How do you update f as m and m as f from the below table testtable?
