Which of the following is the correct syntax to find the maximum value in the column Score from the table Results?

easy📝 Syntax Q3 of 15

SQL - Aggregate Functions

Which of the following is the correct syntax to find the maximum value in the column Score from the table Results?

ASELECT MAX Score FROM Results;

BSELECT MAX[Score] FROM Results;

CSELECT MAX(Score) FROM Results;

DSELECT MAX{Score} FROM Results;

Step-by-Step Solution

Solution:

Step 1: Recall correct function syntax
Aggregate functions like MAX() require parentheses around the column name.
Step 2: Check each option's syntax
SELECT MAX(Score) FROM Results; uses MAX(Score) which is correct SQL syntax; others use invalid syntax.
Final Answer:
SELECT MAX(Score) FROM Results; -> Option C
Quick Check:
Correct syntax uses parentheses [OK]

Quick Trick: Use parentheses with MIN() and MAX() functions [OK]

Common Mistakes:

MISTAKES

Master "Aggregate Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes