If aggregate functions are used to perform operations across entire columns/vertically, How do we perform aggregation ac

[answerhappygod]

If Aggregate Functions Are Used To Perform Operations Across Entire Columns Vertically How Do We Perform Aggregation Ac 1 (43.97 KiB) Viewed 31 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.