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 0.51 Mb.
View original pdf
Page11/48
Date07.04.2021
Size0.51 Mb.
#56254
1   ...   7   8   9   10   11   12   13   14   ...   48
AOH INTERVIEW QUESTIONS
MTS Auth ISSUES
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 0.51 Mb.

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




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

    Main page