Which three are true about subqueries? (Choose three.)
Which three are true about subqueries? (Choose three.)
A subquery can be used in various places within a SQL statement, including in a HAVING clause and a WHERE clause. Thus, options D and F are correct. The usage of < ANY returns true if the argument is less than the highest value returned by the subquery, making option B correct. Therefore, the correct answers are B, D, and F.
I think CDF correct
BDF is correct
BDF is correct
I think BDF, because the answer C is the definition of < All not < Any. If it less than the lowest value, so, it less than all values from the subquery.
BDF is correct
Both B and C are correct. < ANY means less than ANY, no matter highest or lowest. Another doubtful question
No < Any will take the highest value to compare and >any will take the lowest.
BDF for me
"x > ANY (...)": The value must be greater than the smallest value in the list to evaluate to TRUE. "x < ANY (...)": The value must be smaller than the biggest value in the list to evaluate to TRUE. BDF is correct.