Examveda

Which Clause is used to select a particular row from the set of row in an existing table?

A. WHERE

B. FROM

C. ALTER

D. None of the mentioned

Answer: Option A

Solution (By Examveda Team)

This question asks about a special part of a SQL query that lets us pick out specific rows from a table. Imagine you have a table full of information about students, like their names, ages, and grades.

You want to find only the students who are 10 years old. This is where the WHERE clause comes in! It acts like a filter, letting you specify conditions to choose the rows you want.

Here's why the other options are wrong:

FROM tells the query which table to get the data from. It's like saying "look in this table".

ALTER is for changing the structure of the table itself, like adding new columns or changing data types. It doesn't pick rows.

So, the answer is Option A: WHERE because it's used to filter rows based on specific conditions.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous