Wednesday, March 23, 2011

SQL Aggregate Functions

Diffending on value in column this function will return a single value.


•SUM() - Returns the sum
•COUNT() - Returns the number of rows
•FIRST() - Returns the first value
•LAST() - Returns the last value
•MAX() - Returns the largest value
•AVG() - Returns the average value

No comments:

Post a Comment