Skip to Content
-1

How to find Nth Value of an Array in HANA SQL?

How to find Nth Value of an Array in HANA SQL?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 13, 2018 at 11:06 AM

    Hi Nagendra,

    I think you can use LIMIT and OFFSET.

    https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20fcf24075191014a89e9dc7b8408b26.html

    LIMIT <unsigned_integer> [OFFSET <unsigned_integer>]

    If you want to read 10 th record, you can try LIMIT 1 OFFSET 9

    BR,

    Mahesh

    Add comment
    10|10000 characters needed characters exceeded