SQL script complete tutorial – Part 4

Core SAP HANA SQL script concepts- GROUP BY, IN & BETWEEN,ORDER BY Welcome to the fourth installment of this SAP HANA SQL Scripts core concepts section where we try to understand how to use SQL GROUP BY to aggregate rows of data, learn IN and BETWEEN clauses for applying filter with multiple values and also how to […]

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 […]

SQL script complete tutorial – Part 2

Core SAP HANA SQL script concepts- SELECT with SQL WHERE conditions Welcome to the second installment of this SAP HANA SQL Scripts core concepts section where we try to understand the SQL WHERE condition and different ways of using it.  SQL WHERE – Because we only take what we need Most times when we do […]