SQL - Aggregate Functions
Identify the error in the following SQL query:
SELECT MIN Salary FROM Sales;Identify the error in the following SQL query: SELECT MIN Salary FROM Sales;
medium📝 Debug Q6 of 15
Step-by-Step Solution
Solution:
Step 1: Check function syntax
Aggregate functions like MIN require parentheses around the column name.Step 2: Identify the missing parentheses
The query misses parentheses around Salary, causing syntax error.Final Answer:
Missing parentheses around Salary -> Option AQuick Check:
MIN() needs parentheses [OK]
Quick Trick: Always use parentheses with MIN() and MAX() [OK]
Common Mistakes:
MISTAKES- Omitting parentheses
- Wrong table name assumption
- Case sensitivity confusion
Master "Aggregate Functions" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes