E051-04, “GROUP BY can contain columns not in <select list>”

Related

Standard Features

• E051-02, “GROUP BY clause”

  Extensions

  • group by <expression>

  • group by <select item name>

  • group by <unsigned integer>

• E051-06, “HAVING clause”

• T301, “Functional dependencies”

• The ANY_VALUE(…) Aggregate Function: New in SQL:2023 — and a better feature from 1999

Non-standard Features

• Group by All: Generate group by from select

Normative References

E051-04, “GROUP BY can contain columns not in <select list>” is a mandatory feature in ISO/IEC 9075-2:2023. It was already ISO/IEC 9075-2:1999 already.