[
https://issues.apache.org/jira/browse/DERBY-2239?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jazarine Jamal updated DERBY-2239:
----------------------------------
Derby Info: [Patch Available]
> 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
> 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.
