The MAX () function finds the
(A) Maximum number of records entered in a table
(B) Maximum number of rows allowed to be entered
(C) Maximum value of the selected column
(D) None of these
Answer:
The MAX( ) function is an aggregate function in SQL which returns the maximum value from a set of values.
Checking the options
(A) Maximum number of records entered in a table - MAX( ) function does not return this
(B) Maximum number of rows allowed to be entered - MAX( ) function does not return this
(C) Maximum value of the selected column - MAX( ) function returns this
(D) None of these
So, the correct answer is (C)
Made by
Davneet Singh
Davneet Singh is a graduate from Indian Institute of Technology, Kanpur. He has been teaching from the past 12 years. He provides courses for Maths and Science at Teachoo.