Multiple choice technology databases

SQL1117 error means?

  1. DISTINCT NOT ALLOWED

  2. GROUP BY index is not allowed

  3. HAVING is not an aggregate expression

  4. Column function is not allowed

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

SQL1117 indicates that a column function (aggregate function like SUM, COUNT, AVG) was used in a context where SQL syntax rules don't permit it. Column functions require proper grouping or placement in SELECT statements.