The clause that filters JOIN results is called _________
(a) WHERE
(b) SORT
(c) GROUP
(d) GROUP BY
(a) WHERE
(b) SORT
(c) GROUP
(d) GROUP BY
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Correct answer is (a) WHERE
To elaborate: Sometimes the result of a join is very large and is not desirable. In these cases, the results can be filtered with the help of the ‘WHERE’ clause which is followed by a set of condition(s).