Question

Which aggregate function in SQL returns the smallest value from a column in a table?

Options

• MIN()

• MAX()

• SMALL()

• LOWER()

Answer 1

MIN()

Explanation:

The MIN() Function is a built-in SQL aggregate function used to find and return the minimum (smallest) value from a specific column. It works on both numeric and string data, effectively ignoring any NULL values in that column.