<< Click to Display Table of Contents >> Navigation:  Apollo SQL > Arithmetic Functions > STDEV

function StDev( column ): Float

Returns a column's standard deviation for a group of records.

SELECT CUSTNO, cast(sum(amountpaid) as Float), cast(stdev(amountpaid) as Float)

FROM ORDERS

GROUP BY CUSTNO