Welcome to techtalktricks and in this video we will learn about how to use min() and max() in SQL.So stay tuned and watch min and max function in sql.
The MIN function returns the minimum value in a set of values. The MIN function ignores the NULL values. The following is the syntax of the MIN function:
select min(column_name) from table_name;
The MAX functions will return the maximum number or value from the existing data.The MAX function ignores the NULL values.
The following syntax of the MAX function;
select max(column_name) from table_name;
sql min and max in same query
sql max and min in one select
sql min of two values
sql min of two columns
sql select min value from multiple rows
sql min group by
sql max group by
sql select max group by
1.How to make your computer start up & shutdown faster
2.How To Trace Name/Address/Location Of UnKnown Number…