[jira] Commented: (DERBY-2239) Example of SelectExpression for GROUP BY clause is mistaken

["Tomohito Nakayama (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DERBY-2239?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12464433 ] 

Tomohito Nakayama commented on DERBY-2239:
------------------------------------------

I think next description is not correct in the example ....

-- Arrange the result table in ascending order by average departmental salary. 

1 is for WORKDEPT and not AVG(SALARY).

> 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
>
> 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.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira