QUEL Reference Guide > QUEL Reference Guide > QUEL and EQUEL Statements > SET--Set Session Options > Set Aggregate [no]project Option
Was this helpful?
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) 
Last modified date: 01/30/2023