Which aggregate function returns the smallest value in a column?

Advanced SQL Developer Easy

Advanced SQL Developer — Easy

Which aggregate function returns the smallest value in a column?

Key points

  • MIN() is specifically designed to find the smallest value.
  • FIRST() returns the first value in a column, not necessarily the smallest.
  • LEAST() is not a valid SQL aggregate function.
  • BOTTOM() is not a standard SQL function for finding the smallest value.

Ready to go further?

Start full exam Practice more questions

Related questions