Selecting Aggregates from Procedures

From InterBase
Jump to: navigation, search

Go Up to Using Select Procedures in isql


In addition to selecting values from a procedure, you can use aggregate functions. For example, to use ORG_CHART to display a count of the number of departments, use the following statement:

SELECT COUNT(DEPARTMENT) FROM ORG_CHART;

The results are:

COUNT
============
24

Similarly, to use ORG_CHART to display the maximum and average number of employees in each department, use the following statement:

SELECT MAX(EMP_CNT), AVG(EMP_CNT) FROM ORG_CHART;

The results are:

MAX

=

 AVG

=

     5

2

If a procedure encounters an error or exception, the aggregate functions do not return the correct values, since the procedure terminates before all rows are processed.

Advance To: