[
https://issues.apache.org/jira/browse/DERBY-2239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dyre Tjeldvoll updated DERBY-2239:
----------------------------------
Fix Version/s: 10.4.0.0
This issue has no fix version, but has been checked in to trunk after the 10.3
branch was cut, and has not been merged to the 10.3 branch (before the last
release).
(Some have been checked into trunk after 10.4 was cut and then merged to 10.4).
> Example of SelectExpression for GROUP BY clause is mistaken
> -----------------------------------------------------------
>
> Key: DERBY-2239
> URL: https://issues.apache.org/jira/browse/DERBY-2239
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment:
> http://db.apache.org/derby/docs/dev/ref/rrefselectexpression.html
> Reporter: Tomohito Nakayama
> Assignee: Jazarine Jamal
> Fix For: 10.4.0.0
>
> Attachments: DERBY2239-ref.diff, newref.zip
>
>
> There is next example.
> -- List head count of each department,
> -- the department number (WORKDEPT), and the average departmental salary
> (SALARY)
> -- for all departments in the EMPLOYEE table.
> -- Arrange the result table in ascending order by average departmental salary.
> SELECT WORKDEPT, AVG(SALARY)
> FROM EMPLOYEE
> GROUP BY WORKDEPT
> ORDER BY 1
> Comment told that head count of each department is listed, but not exaxtly.
> I think count(*) is needed here.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
