Which two statements are true regarding subqueries? (Choose two.) - ProProfs Discuss
Topics
Products
Follow Us:

Which two statements are true regarding subqueries? (Choose two.)



A. The ORDER BY clause can be used in the subquery
B. A subquery can be used in the FROM clause of a SELECT statement
C. If the subquery returns NULL, the main query may still return result rows
D. A subquery can be placed in a WHERE clause, GROUP BY clause, or a HAVING clause
E. . Logical operators, such as AND, OR and NOT, cannot be used in the WHERE clause of asubquery

This question is part of my quiz 1
Asked by Sreeparna, Last updated: Apr 29, 2020

+ Answer
Request

1 Answer

sreeparna

Sreeparna

Answered Jun 01, 2018

The ORDER BY clause can be used in the subquery
A subquery can be used in the FROM clause of a SELECT statement
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.