Question

In an SQL query, which built-in function is used to obtain the smallest value of numeric columns?

a) AVG
b) COUNT
c) MAX
d) MIN
e) SUM

Answer 1

In SQL, the built-in function to get the smallest value of numeric columns is MIN. It returns the minimum value found within a specified column in a table.

Step-by-step explanation:

The built-in function used to obtain the smallest value from a numeric column in an SQL query is MIN. This function is applied to a column in a table and returns the minimum value found within that column. For example, if you have a table called 'Salaries' with a column 'Amount', you can find the smallest salary by using the query: SELECT MIN(Amount) FROM Salaries;