Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-2239

Example of SelectExpression for GROUP BY clause is mistaken

    Details

    • Issue & fix info:
      Patch Available

      Description

      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.

        Attachments

        1. newref.zip
          799 kB
          Jazarine Jamal
        2. DERBY2239-ref.diff
          0.9 kB
          Jazarine Jamal

          Activity

            People

            • Assignee:
              jazarine Jazarine Jamal
              Reporter:
              naka Tomohito Nakayama
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: