MySQLi MIN is used to return the minimum value of an expression.
Below the syntax of SUM function.
SELECT MIN(aggregate_expression) FROM table_name [conditions];
MySQLi MIN is used to return the minimum value of an expression.
Below the syntax of SUM function.
SELECT MIN(aggregate_expression) FROM table_name [conditions];
<?php
$conn = mysqli_connect('localhost:3306', 'user_name', 'password', 'db_nexladder');
if(! $conn) {
die('Could not connect: ' . mysqli_error());
}
$sql = "SELECT MIN(`working_hours`) AS working_hours FROM `tbl_employee`";
$result = mysqli_query($conn, $sql);
$row = mysqli_fetch_object($result) ;
echo "Minimum Working Hours: " . $row->working_hours;
mysqli_close($conn);
?>
Below it'll look like with MIN Aggregate