At 10:33 PM 11/22/2002 +1100, Helen Borrie wrote:

>Select sum("Col_1") as Total, count("col_1") AS answer
> where "col_2" = '2';

There is a subtle, but sometimes important, difference
between count (<column name>) and count (*). The first
counts only those rows where the column value is not
null. The second counts all matching rows.

Regards,

Ann
www.ibphoenix.com
We have answers.