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.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion