PostgreSQL - Subqueries in PostgreSQL
Which of the following is the correct way to write a query that selects rows where a column value is less than
ALL values returned by a subquery in PostgreSQL?Which of the following is the correct way to write a query that selects rows where a column value is less than ALL values returned by a subquery in PostgreSQL?
easy📝 Syntax Q3 of 15
Step-by-Step Solution
Solution:
Step 1: Understand the syntax for ALL
The correct syntax uses the comparison operator followed byALLand a subquery in parentheses.Step 2: Analyze each option
SELECT * FROM table WHERE column < ALL (SELECT value FROM other_table); correctly usescolumn < ALL (subquery). SELECT * FROM table WHERE column < ANY (SELECT value FROM other_table); uses ANY, which is different. SELECT * FROM table WHERE column = ALL (SELECT value FROM other_table); uses = ALL, which is valid but not the requested comparison. SELECT * FROM table WHERE column IN ALL (SELECT value FROM other_table); uses IN ALL, which is invalid syntax.Final Answer:
SELECT * FROM table WHERE column < ALL (SELECT value FROM other_table); -> Option BQuick Check:
Check for correct operator and parentheses [OK]
Quick Trick: Use operator + ALL + (subquery) syntax [OK]
Common Mistakes:
- Using ANY instead of ALL
- Missing parentheses around subquery
- Using IN with ALL which is invalid
Master "Subqueries in PostgreSQL" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes