[Solved] Which of the following is the correct syntax for a scalar subquery in the SELECT clause? — Ans: SELECT col1, (SELECT MAX(col2) FROM table2) AS max_val FROM table1; | SQL

SQL - Subqueries

Which of the following is the correct syntax for a scalar subquery in the SELECT clause?

ASELECT col1, (SELECT MAX(col2) FROM table2) AS max_val FROM table1;

BSELECT col1 FROM table1 WHERE (SELECT col2 FROM table2);

CSELECT col1, SELECT MAX(col2) FROM table2 FROM table1;

DSELECT col1, MAX(col2) FROM table1, table2;

Step-by-Step Solution

Solution:

Step 1: Review scalar subquery syntax
Scalar subquery is enclosed in parentheses and used as a column expression.
Step 2: Check each option
SELECT col1, (SELECT MAX(col2) FROM table2) AS max_val FROM table1; correctly uses parentheses and alias for scalar subquery in SELECT.
Final Answer:
SELECT col1, (SELECT MAX(col2) FROM table2) AS max_val FROM table1; -> Option A
Quick Check:
Correct scalar subquery syntax = SELECT col1, (SELECT MAX(col2) FROM table2) AS max_val FROM table1; [OK]

Quick Trick: Scalar subquery must be in parentheses in SELECT [OK]

Common Mistakes:

MISTAKES

Master "Subqueries" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which of the following is the correct syntax for a scalar subquery in the SELECT clause?