23 January 2014

Aggregate function in SQL Server

  1.     AVG() - Returns the average value
  2.     COUNT() - Returns the number of rows
  3.     MAX() - Returns the largest value
  4.     MIN() - Returns the smallest value
  5.     SUM() - Returns the sum

No comments:

Post a Comment