Q. What are different types of SQL functions?
Answer =
(i) Single Row (or Scalar) functions.
(ii) Multiple Row (or Group or Aggregate) functions.
--- (i) Single Row Functions work with a single row at a time. A single row function returns a result for every row of a queried table.
--- (ii) Multiple Row or Group Functions work with data of multiple rows at a time and return aggregated value.
(ii) Multiple Row (or Group or Aggregate) functions.
--- (i) Single Row Functions work with a single row at a time. A single row function returns a result for every row of a queried table.
--- (ii) Multiple Row or Group Functions work with data of multiple rows at a time and return aggregated value.
Post a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )