SQLite Forum

meaning of "GROUP BY CONSTANT"
Login
Whoa!  I can specify a plain integer in a GROUP BY to avoid having to retype the original expression?  I knew I could do this for ORDER BY, but this is news to me.  Where is this documented?  I did not see it in the GROUP BY Documentation.  I suspect this is not "standard" SQL.