[Solved] Which of the following is the correct syntax for a subquery in PostgreSQL? — Ans: SELECT * FROM table WHERE column = (SELECT MAX(column) FROM table); | PostgreSQL

PostgreSQL - Subqueries in PostgreSQL

Which of the following is the correct syntax for a subquery in PostgreSQL?

ASELECT * FROM table WHERE column == (SELECT MAX(column) FROM table);

BSELECT * FROM table WHERE column = (SELECT MAX(column) FROM table);

CSELECT * FROM table WHERE column = SELECT MAX(column) FROM table;

DSELECT * FROM table WHERE column IN SELECT MAX(column) FROM table;

Step-by-Step Solution

Solution:

Step 1: Identify correct subquery syntax
Subqueries must be enclosed in parentheses and used with comparison operators like = or IN.
Step 2: Check each option
SELECT * FROM table WHERE column = (SELECT MAX(column) FROM table); correctly uses parentheses and = with a subquery. The other options have syntax errors like using == instead of =, omitting parentheses entirely, or missing them after IN.
Final Answer:
SELECT * FROM table WHERE column = (SELECT MAX(column) FROM table); -> Option B
Quick Check:
Subqueries need parentheses and proper operators [OK]

Quick Trick: Subqueries always go inside parentheses [OK]

Common Mistakes:

Master "Subqueries in PostgreSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which of the following is the correct syntax for a subquery in PostgreSQL?