# CTE Resource Center - Verso - Database Design and Management (Oracle) Task 1415334616

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Distinguish between the two categories of functions in SQL.

Definition

Distinction should include
  • single-row functions, which return a result (e.g., character, number, date, conversion) for a selected row
  • group functions, which select multiple rows of data but return only one result (i.e., avg, count, max, min, stddev, sum, variance).