[ http://issues.apache.org/jira/browse/DERBY-883?page=comments#action_12411924 ]
Lluis Turro commented on DERBY-883: ----------------------------------- About question 2. Results would not change but would be a shortcut. If you ask me I would tell you that reads better 'group by x'. Remember you can also group fields in where clause and they don't need to appear in the select list. select sum(quantity) from client group by clientId I got a list of 'quantity' where to perform operations, but don't care which client provides each element. > Enhance GROUP BY clause to support expressions instead of just column > references. > --------------------------------------------------------------------------------- > > Key: DERBY-883 > URL: http://issues.apache.org/jira/browse/DERBY-883 > Project: Derby > Type: New Feature > Components: SQL > Versions: 10.1.2.1 > Environment: JDK 1.5.0_05 > Reporter: Lluis Turro > Assignee: Manish Khettry > > This select would return an error syntax on finding "(" after month if group > by clause: > select idissue, month(creation), year(creation), count(distinct idissue) > where > .... > group by idissue, month(creation), year(creation) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
