on 10-27-2015 5:15 AM
how to use with statement in hana query,ie how to replace with statement in sql to hana
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
simple example:
with X as (select * from "foo"."bar") select * from TABLEZ, X where.....
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.