SQL script complete tutorial – Part 5

Core SAP HANA SQL script concepts- String Functions Welcome to the fifth installment of this SAP HANA SQL Scripts core concepts section where we try to understand how to use different string functions and operators to manipulate character data sets. The String manipulation begins… It’s now time to pick up the EMP_NAMES table which contains the first name and […]

SQL script complete tutorial – Part 3

Core SAP HANA SQL script concepts- Calculated fields and Alias Welcome to the third instalment of this SAP HANA SQL Scripts core concepts section where we try to understand how to create new calculated fields and how to rename field names using SQL alias concept.  Now let’s play with transaction data for a while. Let’s see how data […]