Which function returns the highest value in a column?

SQL Data Analyst Easy

SQL Data Analyst — Easy

Which function returns the highest value in a column?

Key points

  • MAX() is specifically designed to find the highest value.
  • TOP() is used to limit the number of rows returned, not to find the maximum value.
  • HIGHEST() and CEILING() are not standard SQL functions for finding the highest value.

Ready to go further?

Related questions