MySQL Aggregate Functions || Min ( ) ,Max ( ) Functions || Code With Neha

So In my last video of mysql series I have discussed about order by keyword
You can check the video from the above i button
Or you can watch all of my mysql videos from the playlist itself

So let's get back to the today's topic i•e
aggregate functions mysql

MySQL's aggregate function is used to perform calculations on multiple values and return the result in a single value like the average of all values, the sum of all values, and maximum & minimum value among certain groups of values.

MySQL MIN() and MAX() Functions

The MIN() function returns the smallest value of the selected column.

MIN() Syntax

SELECT MIN(column_name)
FROM table_name
WHERE condition;

The MAX() function returns the largest value of the selected column

MAX() Syntax

SELECT MAX(column_name)
FROM table_name
WHERE condition;

So let's apply this practically ,

Here we are using product table under order_info database as example

To select min price from the table

The query will be
Select min(price)
From products

Similarly to select max price from the table

Select max(price)
From products

So that's all for today Hope you all will get some help from this video
If it's so then don't forget to subscribe my channel Code with Neha and press the Bell Icon for Regular Updates
See you in the next video till then Stay Safe Stay Happy

#mysqlaggregatefunctions
#aggregatefunctions
#mysqlavgfunction
#mysqlavgfunctiontutorial
#mysqlminmaxfunction
#mysqlaggregatefunctions
#mysqlsumfunction
#aggregatefunctionsmysql
#aggregatefunctionsinmysql
#aggregatefunctionssql
#aggregatefunctionsindbms
#SQLAggregateFunctionsSUM
#SQLAggregateFunctionCOUNT
#SQLAggregateFunctionMINMAX
#SQLSubqueries
#sqlaggregatefunctionssum
#sqlaggregatefunctionavg
#sqlaggregatefunctioncount
#aggregatefunctionsinoracle
#aggregatefunctionsinsqlserver
#aggregatefunctionsandgrouping
#aggregatefunctionsinmysql
#aggregatefunctionsdbms
#SQL
#aggregate
#having
#clause
#LearnSqlServer
#sql
#sqltutorial
#mysqltutorial
#mysqltutorialforbeginners