In this blog, I will tell you how to use max
and min function to find out the maximum and minimum value.
Here we are finding the maximum and minimum
value by using the sql. Here First we make a table which have two column, first
column name is name and second column name is marks. So here we find the maximum
and minimum marks from the table. So there is a table which is shown below:
For finding the maximum value from the table
we use max function.
SELECT MAX (column_name) FROM table_name
Example For MAX() Function
SELECT MAX (marks)As MaximumMarks FROM
For finding the minimum value from the table
we use min function.
SELECT MIN (column_name) FROM table_name
Example For MIN() Function
SELECT MIN(marks) As MinimumMarks FROM akash3