Q. When do you use “GROUPBY” clause in HANA SQL statements? Ans: while using aggregate functions in a SELECT QUERY, all the columns that do not belong to aggregate-functions should be put in GROUP BY Clause. Q. What is the significance of HAVING clause in SQL statement? Ans: In order to apply further filter for the aggregation function, HAVING clause can be used in the SELECT statement which is used with GROUPBY clause being mandatory. Eg. It is like applying where condition on the aggregated column. When an aggregation is used with CASE statement, it has to be mentioned in the GROUPBY clause
