ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

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

Answer & Solution
Correct Answer: Option B
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.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.