Progress
Embedded SQL-92
Guide and Reference


NULL Values in a GROUP BY Clause

When you apply a GROUP BY clause to a column containing NULL values, all NULL values are placed into the same group.

EXAMPLE

In the following example the SELECT statement returns a count and a list of employee names (ename). All the employees who are not assigned to a project (projno) are grouped together in the result set:

EXEC SQL
     SELECT ename, COUNT (*) FROM employee
     GROUP BY projno ; 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095