A subquery in an SQL SELECT statement:
A. can only be used with two tables.
B. can always be duplicated by a join.
C. has a distinct form that cannot be duplicated by a join.
D. cannot have its results sorted using ORDER BY.
Answer: Option B
Solution (By Examveda Team)
A subquery in an SQL SELECT statement is a query within another query. It can always be duplicated by a join because the purpose of a subquery can often be achieved using a join operation. Joins provide a way to combine rows from two or more tables based on related columns, effectively replicating the results of many subqueries.This Question Belongs to User Ask Question >> Miscellaneous
Join The Discussion