|
What is “Group by” in Select statement?
SAP Reports,SAP DB,ALE, SAP Tables questions and answers
(Continued from previous question...)
What is “Group by” in Select statement?
Answer1:
Group by is used to fetch a unique data from a column.
Answer2:
A "group by" is used to group selected rows in a table to perform arg functions on them. Rows not included in the "group by" clouse and not part of ARG functions cannot be used ...(logical grouping of data) or orerations performed (on groups of data) can be used with the "HAVING" clause to further refine the output.
ex of some ARG functions : SUM() , MIN(),MAX(), AVG()
(Continued on next question...)
Other Interview Questions
| 