cancel
Showing results for 
Search instead for 
Did you mean: 

row_number OVER Partition by Column_name

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

bhanu_prakash37
Explorer

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

Answers (1)

Answers (1)

Former Member

used gen_row_num_by_group(column_name) function after sorting