The SQL set functions give you a quick answer to questions you may have about the characteristics of your data as a whole. How many rows does a table have? What is the highest value in the table? What is the lowest? These are the kinds of questions that the SQL set functions can answer for you.
| COUNT | Returns the number of rows in the specified table |
| MAX | Returns the maximum value that occurs in the specified table |
| MIN | Returns the minimum value that occurs in the specified table |
| SUM | Adds up the values in a specified column |
| AVG | Returns the average of all the values in the specified column |
dummies
Source:http://www.dummies.com/how-to/content/sql-set-functions0.html
No comments:
Post a Comment