1.MIN (minimum value)
Syntax:
|
1 2 |
SELECT MIN(column_name) FROM table_name; |
example:
|
1 2 |
SELECT MIN(price) FROM cars; |
2. MAX (maximumvalue)
Syntax:
|
1 2 3 |
SELECT MAX(column_name) FROM table_name; |
Example:
|
1 2 3 |
SELECT MAX(price) FROM cars; |
3. COUNT (number of rows)
Syntax
|
1 2 3 |
SELECT COUNT(column_name) FROM table_name; |
Example:
|
1 2 3 |
SELECT COUNT(*) FROM cars; |
4. AVG (average value):
|
1 2 3 |
SELECT AVG(column_name) FROM table_name; |
Example:
|
1 2 3 |
SELECT AVG(price) FROM cars; |
5. SUM (sum of values):
Syntax
|
1 2 3 |
SELECT SUM(column_name) FROM table_name; |
Example:
|
1 2 3 |
SELECT SUM(price) FROM cars; |
Note: In the examples above, the cars table is assumed to have a column named price.