Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 23723 Views
- Cap Gemini, TCS, I also Faced
- E-Mail Answers
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
discuss about myisam index statistics collection. : Sql dba
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
What is %type in sql?
How to revise and re-run the last sql command?
What is sorting in sql?
Is inner join same as self join?
Is it important to partition hard disk?
What is pl sql block structure?
How many types of triggers exist in pl/sql?
What does select * from mean in sql?
What is right join sql?
What is the main reason behind using an index?
In pl/sql, what is bulk binding, and when/how would it help performance?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
Why does sql need a server?
