Which of the following is the correct syntax to find the maximum salary from a table named Employees?

easy📝 Syntax Q12 of 15

SQL - Aggregate Functions

Which of the following is the correct syntax to find the maximum salary from a table named Employees?

ASELECT MAX salary FROM Employees;

BSELECT MAX{salary} FROM Employees;

CSELECT MAX[salary] FROM Employees;

DSELECT MAX(salary) FROM Employees;

Step-by-Step Solution

Solution:

Step 1: Recall correct function syntax
The correct syntax for SQL aggregate functions like MAX() requires parentheses around the column name.
Step 2: Check syntax
SELECT MAX(salary) FROM Employees; uses MAX(salary) which is correct. Forms without parentheses or using [] {} are invalid.
Final Answer:
SELECT MAX(salary) FROM Employees; -> Option D
Quick Check:
MAX() uses parentheses around column [OK]

Quick Trick: Use parentheses around column name in MAX() [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