ABS is a scalar function that operates on individual values, while AVG, SUM, and STDDEV are aggregate functions that operate on sets of values and require GROUP BY or appear in HAVING clauses. Scalar functions can be used anywhere expressions are allowed.