Count SQL Function

The Count() function is an aggregate function which takes one (1) argument and returns the count of all non-null values, if there are no non-null values then it will return null.

/* Following will return actual SUM as integer */ 

SELECT Sum(OrderAmount);