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 / 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 are the type of locks ? : Sql dba
Why do we use set serveroutput on?
Define join and name different types of joins?
What is cursor in pl sql?
Why we use stored procedure instead of query?
How do I delete a trigger?
Can sql function call stored procedure?
What is pl sql commands?
What is data profiling in sql?
What are the steps for performance tuning.
Which function is used to return remainder in a division operator in sql?
Why is sql*loader direct path so fast?
how does a local variable is defined using t-sql? : Transact sql
What are the differences between implicit and explicit cursors?
how can we destroy the cookie? : Sql dba