how are rank and dense rank being alloted for column with same values over a particular column
Answer Posted / shipra gupta
salary R DR
800 1 1
800 1 1
200 3 2
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the non-standard sql commands supported by 'mysql'? : Sql dba
What is mutating sql table?
Which software is used for pl sql programming?
what are the nonstandard string types? : Sql dba
what is the difference between union and union all? : Sql dba
What is trigger explain it?
What is an ndf file?
How do I access sql anywhere database?
What is mutating table error?
What is the need of merge statement?
Is keyword pl sql?
What is pl sql in oracle?
What is bind reference and how can it be created?
differentiate between float and double. : Sql dba
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