Introduction to SQL - Technical MCQs

Q1:

Which of the following is the correct order of keywords for SQL SELECT statements?

A SELECT, FROM, WHERE

B FROM, WHERE, SELECT

C WHERE, FROM,SELECT

D SELECT,WHERE,FROM

ANS:A - SELECT, FROM, WHERE

The answer is B because from clause execute first and at last select clause execute.

FROM -> WHERE -> GROUP BY -> HAVING -> SELECT -> ORDER.