Vidyalelo
MySQL · Q617

MySQL

Programming · MySQL · question 617

Q617

Which clause is mandatory with clause "SELECT" in Mysql?

A.
FROM
Answer
B.
WHERE
C.
Both FROM and WHERE
D.
None of the mentioned

Answer: Option A

Solution

Answer: Option A
Solution:
This question is about the parts of a MySQL query that lets you get information from a database.

The SELECT clause tells the database what data you want to retrieve.

The FROM clause tells the database which table to look in for the data.

The WHERE clause is optional and filters the data to get only the rows that meet certain conditions.

Since you always need to specify the table to fetch data from, the FROM clause is required with SELECT.

So the correct answer is Option A: FROM.