SQL MIN/MAX Statements
Finding the minimum or maximum value in a set of data can also be extremely useful.
This can be achieved with the MIN/MAX commands as follows:-
This can be achieved with the MIN/MAX commands as follows:-
SELECT MAX (Balance)
FROM SecA_Bal
WHERE AGENT=Dowling:
FROM SecA_Bal
WHERE AGENT=Dowling:
This query will tell us which the highest balance any customer owes agent Dowling is 553.50.
The aggregate functions can be combined, and used in conjunction with each other and with other commands.
For example:
The aggregate functions can be combined, and used in conjunction with each other and with other commands.
For example:
SELECT SUM (Balance), AVG (Balance)
FROM SecA_Bal;
FROM SecA_Bal;
The aggregate functions are essential to SQL as they greatly increase the scope of the language in terms of data manipulation, and it’s capability in terms of serving different users needs.
Aggregate functions are typically used in summarizing data and generating repots, and thus add value to data for management and other users not directly working with the database.
