MAX « Aggregate Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Aggregate Functions
  3. MAX
1.MAX: return the highest values in a column, ignore NULLs
2.Syntax: MAX ([DISTINCT]|[ALL] )
3.Use MAX with dates, it gives you the most recent dates
4.MAX with character data, retrieves the highest value alphabetically (that is, closest 'z').
5.Max with null value
6.Max - Min
7.Display the order number and total order price of the order(s) with the maximum total order price
8.max(total_price) - min(total_price)
9.Who have the max value




10.All rows with the max value