Skip to Content
avatar image
Former Member

how to use with statement in hana query

how to use with statement in hana query,ie how to replace with statement in sql to hana

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 28, 2015 at 11:24 PM

    simple example:

    with X as (select * from "foo"."bar")
    
    select * from TABLEZ, X where.....
    

    you might also want to watch the video from the SAP HANA Academy about it here SAP HANA Academy - SQL Functions: SELECT WITH - YouTube

    Best

    Add comment
    10|10000 characters needed characters exceeded