on 12-16-2015 2:15 AM
Hi ,
Please guide how to use Oracle Row_number function in BODS.
I have a sql using "row_number( ) OVER Partition by Column_name". I dont want to use SQL transform in this case.
Thanks
Hi Harsh,
We have function in bods called gen_row_num_ group().
It will generate row no.use order by befor using this function.
Bhanu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
used gen_row_num_by_group(column_name) function after sorting
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.