Question

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

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

Answer 1

The SQL MAX function is used to obtain the largest value in a column.

Step-by-step explanation:

In an SQL query, the built-in function used to obtain the largest value of numeric columns is c) MAX. The MAX function can be applied in a SELECT statement to find the biggest number in a specified column. For example, if you have a table named 'Sales' with a column 'Amount', you would use SELECT MAX(Amount) FROM Sales; to get the highest sale amount recorded in that table.