Skip to Content
0
Jun 07, 2018 at 05:56 PM

How to implement LAST_VALUE function in Graphical calculation view?

461 Views Last edit Jun 07, 2018 at 05:57 PM 2 rev

Hi Experts,

We have one requirement in our project where we wanted to pick up the last value of a column by ordering another column .In the following example , i want to pick up the last product name order by product id.

select LAST_VALUE (PRODUCT_NAME ORDER BY PRODUCT_ID ) from product.

How can this requirement be acheived in Graphical calculation view?

Thanks

Akshay