Lab Sql

I'm passing Sql Staments from Ms sql server to Sap Hana Sintaxis (There are inside an xml file)… Read more Greater Than Operator > In Hana

The target is to create all possible combinations of joining the two columns using SAP HANA SQL. ev… Read more Sap Hana Sql Query To Find All Possible Combinations Between Two Columns

I want to split multiple values from a row into a separate row in sap hana sql. table : id name … Read more How To Split Multiple Values From A Row Into Separate Rows?

I need to unpivot some data in SAP HANA. I set up an example table to try it out on, but I still ca… Read more How To Unpivot In Sql? (sap Hana) (columns To Rows)

DECLARE VI_CNT INTEGER DEFAULT 0; DECLARE VI_IDX INTEGER; DECLARE VI_LIMIT INTEGER; DECLARE VS_OUTP… Read more Hana Sql Select Count (*) From Multiple Tables Found In A Table

I have a query which returns the table which is like SELECT (CASE WHEN type=1 THEN 'A' … Read more How To Get The Transpose In Sql (hana)?

I want looked for 'if exists', but sap hana sql was not understand for 'if exists'.… Read more If Exists Statement Alternative In Hana

I have some tables on SAP HANA and „create column table“ to combine multiple „raw tables“ and need … Read more SQL - SAP HANA - REPLACE_REGEXPR In Column Table