Vidyalelo
MySQL · Q756

MySQL

Programming · MySQL · question 756

Q756

Which clause is used to "Filters out unwanted data"?

A.
FROM
B.
WHERE
Answer
C.
SELECT
D.
ORDER BY

Answer: Option B

Solution

Answer: Option B
Solution:
This question is about how to pick out specific information from a database using SQL (Structured Query Language). Imagine you have a big table full of data like a spreadsheet, and you only want to see certain rows. That's where the WHERE clause comes in!

Think of it like using a filter on a coffee machine – you choose the criteria, and the filter only lets through what you want. The WHERE clause lets you set conditions to pick specific rows based on values in your columns.

Let's look at the other options:
* FROM tells the database which table you want to work with.
* SELECT chooses which columns you want to see.
* ORDER BY arranges the rows in a specific order.

So the answer is Option B: WHERE.