This article explains how we can calculate maximum and minimum value of all the values in a particular column.To do so, MAX() and MIN() functions are used in MySQL.
The MAX() function
SELECT MAX(column) FROM table;
To find maximum of all the values in a particular column using MAX function in MySQLi, pass the query for finding maximum values to the query function of the mysqli object. The following example finds maximum of all the ages in the patient_age column of patient table.
Using MAX Function in Mysqli connect_error) { die("Connection not established: " . $connection->connect_error); } $query = "Use Hospital;"; $connection->query($query); // Using MAX Function $query = "SELECT MAX(patient_age) ". "FROM Patient "; $output = $connection->query($query); if ($output->num_rows > 0) { // output data of each row while($row = $output->fetch_assoc()) { echo "Maximum age is " . $row["MAX(patient_age)"]."
"; } } else { echo "0 results"; } $connection->close(); ?>
Using MIN() function in MySQL
The syntax of MIN function is as followsL
SELECT MIN(column) FROM table;
To find minimum of all the values in a particular column using MIN function in MySQLi, pass the query for finding maximum values to the query function of the mysqli object. The following example finds minimum of all the ages in the patient_age column of patient table.
Using MIN Function in Mysqli connect_error) { die("Connection not established: " . $connection->connect_error); } $query = "Use Hospital;"; $connection->query($query); // Using MIN Function $query = "SELECT MIN(patient_age) ". "FROM Patient "; $output = $connection->query($query); if ($output->num_rows > 0) { // output data of each row while($row = $output->fetch_assoc()) { echo "Minimum age is " . $row["MIN(patient_age)"]."
"; } } else { echo "0 results"; } $connection->close(); ?>