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

Question

Quizplus · Accepted Answer

The built-in function MAX is used to obtain the largest value of numeric columns in an SQL query. AVG calculates the average value of numeric columns, COUNT counts the number of rows or non-null values in a column, and MIN obtains the smallest value of numeric columns. Therefore, the best choice is C as it directly addresses the requirement of obtaining the maximum value.

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