Q. What is the difference between Row Storage and Column Storage? Row Store


Q. When do you use “GROUPBY” clause in HANA SQL statements?



Download 156.8 Kb.
View original pdf
Page11/48
Date07.04.2021
Size156.8 Kb.
1   ...   7   8   9   10   11   12   13   14   ...   48
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

Download 156.8 Kb.

Share with your friends:
1   ...   7   8   9   10   11   12   13   14   ...   48




The database is protected by copyright ©ininet.org 2020
send message

    Main page