Examveda

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

A. FROM

B. WHERE

C. Both FROM and WHERE

D. None of the mentioned

Answer: Option A

Solution (By Examveda Team)

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous