Examveda

The clause that filters JOIN results is called . . . . . . . .

A. WHERE

B. SORT

C. GROUP

D. GROUP BY

Answer: Option A

Solution (By Examveda Team)

Imagine you have two tables, one with customer information and another with their orders. When you want to combine these tables, you use a JOIN to connect related data.

Now, if you want to show only the orders placed by customers in a specific city, you need to filter the results. This is where the WHERE clause comes in. It acts like a filter, letting you select only the rows that meet a certain condition.

So, the answer is Option A: WHERE.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous