Home » RDBMS Server » Server Administration » aggregate functions and zero values
aggregate functions and zero values [message #371856] |
Thu, 14 December 2000 10:20 |
Jon Oddvar Sellereite
Messages: 1 Registered: December 2000
|
Junior Member |
|
|
How to use Avg, Min, Max and request this functions to neglect zero values. If I have the Sql statement: Select Sum(Field1), Avg(Field2) From
Where <...> Group by <....>, And I want the average to be calculated with only values greater than zero. "Avg(Field2>0)" ??
|
|
|
|
|
Goto Forum:
Current Time: Sat Jan 11 01:56:19 CST 2025
|