How to Use sql Aggregate Functions


  Top Tutorials     New Tutorials     Submit     Login     Register  

Tutorial Detail

How to Use sql Aggregate Functions

Want to find out the minimum or average on a given data? Learn to use SQLs aggregate function for this.
  • Total Hits: 13344

  • Average Rating :
    URL RatingURL RatingURL RatingURL RatingURL Rating


  • Total Votes: 154 votes

  • Category: Basic SQL/Basic SQL Misc

  • Submitted on: 2008-04-11 10:19:37

  • Submitted By: Shekhar

  • Set as Favorite


Aggregate means a whole, the term is most used in economics (if you have ever taken an economics class, you probably remember how painful it was :)), it basically means ‘as a whole’. So, we’ll cover a few simple aggregate functions , avg,max, and min.    More detail...

Rating Detail

 Stars  Percentage  Total Vote
 One star  Vote LeftVote MiddleVote Right 36.36%  56
 Two starsTwo star  Vote LeftVote MiddleVote Right 9.74%  15
 Three starsThree starsThree stars  Vote LeftVote MiddleVote Right 11.04%  17
 Four starsFour starsFour starsFour stars  Vote LeftVote MiddleVote Right 12.34%  19
 Five starsFive starsFive starsFive starsFive stars  Vote LeftVote MiddleVote Right 30.52%  47

Caste Your Vote

 Rating  Selection  Guidelines
 Poor:     Very disappointing, useless.
 Fair:     Below average, disappointing but not useless.
 Good:     About average in its class.
 Very Good:     Above average for its category.
 Excellent:     One of the best Tutorials in its category.