Page 1 of 1
If aggregate functions are used to perform operations across entire columns/vertically, How do we perform aggregation ac
Posted: Fri Jul 08, 2022 6:36 am
by answerhappygod
- If Aggregate Functions Are Used To Perform Operations Across Entire Columns Vertically How Do We Perform Aggregation Ac 1 (43.97 KiB) Viewed 37 times
If aggregate functions are used to perform operations across entire columns/vertically, How do we perform aggregation across rows/horizontally? By using ROW_SUM function i.e. SELECT ROW_SUM (coll, col2) AS coll_plus_col2 FROM table; By using simple arithmetic, i.e SELECT (coll + col2) AS coll_plus_col2 FROM table; Aggregate functions can perform operations across rows/horizontally also, i.e. SELECT SUM (coll, col2) AS coll_plus_col2 FROM table; Aggregate functions can only be performed on columns/vertically and not on rows/horizontally.