?
Which clause is mandatory with clause "SELECT" in Mysql?
Answer & Solution
Correct Answer:
Option
A
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.
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.
Join the Discussion
Login to post a comment or share your explanation.
Login