Multiple choice technology databases

What are the two types of SQL Functions?

  1. Single-row Functions and Double-row Functions

  2. One-row Functions and Two-row Functions

  3. Single-row Functions and Multiple-row Functions

  4. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SQL functions are broadly categorized into single-row functions, which operate on single rows and return one result per row, and multiple-row (or group/aggregate) functions, which operate on sets of rows to return a single result. Double-row or two-row functions do not exist.

Keep practicing — related questions