Question

Explanation of Select - From - Where Clause in SQL
Hi, I don't understand SELECT - FROM - WHERE clause in SQL. Please explain me.

Answer 1

SELECT :clause is like choose
FROM: is the relation name drom where to chose
WHERE: it is for giving some specific characterstics

for example:
if you are said to select apples from fruit basket of red color
then the clauses will be like
SELECT apples
FROM fruitbasket
WHERE color=red;

hope that helps