Question - What is “Group by” in Select statement?
Answer -
1: -
Group by is used to fetch a unique data from a column.
2: -
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()
Select statement to read data into internal tables. Types of Select statements
select * from database table into (internal table name)
the above statement collects data into the header area of the internal table.
and
select * from database table into table (internal table name)
the above statement collects the data into the body area directly .