PostgreSQL - Subqueries in PostgreSQL
What will be the output of this query?
SELECT name FROM employees WHERE salary > (SELECT AVG(salary) FROM employees);
What will be the output of this query?
medium📝 query result Q13 of 15
Step-by-Step Solution
Solution:
Step 1: Understand the subquery
The subquery(SELECT AVG(salary) FROM employees)calculates the average salary of all employees.Step 2: Apply the condition in the main query
The main query selects employee names where their salary is greater than this average.Final Answer:
Names of employees earning more than the average salary -> Option DQuick Check:
Subquery returns average; main query filters salaries above it [OK]
Quick Trick: Subqueries can return single values to compare in main query [OK]
Common Mistakes:
- Thinking it returns employees below average
- Assuming syntax error due to subquery
- Confusing AVG with SUM
Master "Subqueries in PostgreSQL" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes