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

Question

Quizplus · Accepted Answer

The MIN function is used to obtain the smallest value of a numeric column in an SQL query. The AVG function calculates the average value of a numeric column, the COUNT function counts the number of rows in a table or a specified column, and the MAX function returns the maximum value of a numeric column.

In an SQL Query,which Built-In Function Is Used to Obtain