6. QUEL and EQUEL Statements : Set Statement—Set Session Options : Description : Set Aggregate [no]project Option
 
Share this page                  
Set Aggregate [no]project Option
Specifies whether the DBMS Server returns zero values for aggregate functions that use the by clause. In the following example, if you specify the project option, the DBMS Server returns a value for each department, zero for those departments that have no employees earning over $10,000. If you specify noproject, departments that have no employees earning over $10,000 are omitted:
count(emp.salary by emp.dept where emp.salary > 10000)