Reference > Prepare Methods
urank(value)
Definition
Integer urank(Comparable value)
Description
will evaluate value for all rows and the lowest value will get 1, 2nd will get 2, etc. If multiple rows value evaluate to the same value, the first occurrence gets the lower value.
Parameter Definition
Example
| Prepare *,urank(Price) as Sample from SampleData Partition by Symbol
|
| +------+--------+-----+------+
|Symbol|Sequence|Price|Sample|
+------+--------+-----+------+
|CAT |1 |50.0 |1 |
|CAT |2 |54.0 |4 |
|CAT |3 |52.0 |2 |
|CAT |4 |52.0 |3 |
|CAT |5 !null !null |
|CAT |6 |57.0 |5 |
|IBM |1 |20.0 |1 |
|IBM |2 |24.0 |3 |
|IBM |3 |22.0 |2 |
|IBM |4 |27.0 |4 |
|IBM |5 !null !null |
+------+--------+-----+------+
|