MIN « Aggregate Functions « SQL / MySQL






  1. SQL / MySQL
  2. Aggregate Functions
  3. MIN
1.Returns the minimum value from a group of values: MIN()
2.And to find the lowest commission that any of the sales staff is earning, use this:
3.Use MIN( ) or MAX( ) With a GROUP BY clause
4.MIN( ) and MAX( ) also work with expressions or values that are derived from column values.
5.Do calculation with aggregate function
6.Controlling String Case Sensitivity for MIN( ) and MAX( )
7.What are the lowest and highest U.S. state populations?
8.To make bstr not case sensitive, you can convert the values to a given lettercase:
9.What are the shortest and longest trips in the mytable table?