Finding the minimum and maximum values
MySQL provides inbuilt functions to find the minimum and maximum values.
SQL provides 5 aggregate functions. They are:
In this session of the online MySQL course, we’ll look at finding the minimum and maximum values in a column.
select MIN(salary) from employee_data; +-------------+ | MIN(salary) | +-------------+ | 70000 | +-------------+ 1 row in set (0.00 sec)
select MAX(salary) from employee_data; +-------------+ | MAX(salary) | +-------------+ | 200000 | +-------------+ 1 row in set (0.00 sec)
Finding the average and sum Totalling column values with MySQL SUM The SUM() aggregate function calculates the total of values in a column. You require ...
SQL Tutorial What is SQL? The Structured Query Language is used in manipulating data stored in Relational Database Management Systems (RDBMS). SQL provides commands ...
Column Types part 2 MySQL Text data type Text can be fixed length (char) or variable length strings. Also, text comparisions can be case sensitive ...
Creating tables In this section of the mysql training course we will explore the MySQL commands to create database tables and selecting the database. Databases ...
Inserting data in MySQL tables Inserting data into tables The INSERT SQL statement impregnates our table with data. Here is a general form of INSERT. ...