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 / abin
Select sal from (Select *,ROW_NUMBER() over (partition by
sal order by sal asc)num from emp) a
Where num=1
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is a loop in sql?
Is not equal in sql?
What are the parts of a basic sql query?
Can I call a procedure inside a function?
when is the use of update_statistics command? : Sql dba
How do I clear the screen in sql plus?
Is pl sql and postgresql same?
Why functions are used in sql?
Is primary key an index?
What is sql*loader?
What is sql engine in oracle?
How do I find duplicates in the same column?
What is java sql drivermanager?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What is sql profiler in oracle?