Hi , I am trying Common Table Expression(CTE) using below example but its not working , can you please tell how to implement CTE in KSQL where I want to select from table or topic. WITH cteSample (VBELN, MANDT, POSNR) AS ( SELECT lips.VBELN,lips.MANDT,lips.POSNR FROM JSON_LIMITED_2_LIPS_S1…

Handling of Common Table Expression

rmoff Split this topic 11 February 2021 11:06 6

Topic		Replies	Views
Handling of Windowing function in KSQL like ROW_NUMMBER() , RANK() and DENSE_RANK() ksqlDB	8	4025	16 July 2021
How does ksqlDB work? – Free resources to learn more ksqlDB	1	3072	31 December 2021
Aggregation for complex structures ksqlDB	3	3564	20 June 2021
Equivalent of SQL Union in KSQLDB ksqlDB	4	3999	1 October 2022
MAX aggregate Function with Varchar ksqlDB	2	3371	17 February 2021