db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lluis Turro (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-883) Enhance GROUP BY clause to support expressions instead of just column references.
Date Tue, 16 May 2006 08:30:07 GMT
    [ 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


Mime
View raw message