Database - Introduction to SQL - Discussion

Discussion :: Introduction to SQL - General Questions (Q.No.12)

12. 

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

Answer: Option A

Explanation:

No answer description available for this question.

Sandeep said: (Jan 27, 2011)  
SELECT * FROM CUSTOMER WHERE CUST_ID=1234;

Ashok said: (Feb 12, 2011)  
First fetch the customer table from database and condition will be checked for that cust_id 1234 and finally gives the result which coloum will selects from data base.

May be this answer is B.

Bhavin Patel said: (Sep 29, 2013)  
Select * From Table name Where this id = this id;

Jaspreet said: (Jun 1, 2016)  
The answer is B, select is the last to execute.

Please correct the answer.

Or let me know if I have understood the question wrongly. Please inform me.

Kiran Pandit said: (Aug 29, 2018)  
I think, the correct order is FROM -> WHERE -> GROUP BY -> HAVING -> SELECT -> ORDER.

Vishal Yenge said: (Nov 10, 2018)  
The answer is B because from clause execute first and at last select clause execute.

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

Myma said: (Aug 3, 2019)  
Exactly (B) is correct.
From ->(tablename).
Where->(filter the records).
Select->(display the filter records).

Post your comments here:

Name *:

Email   : (optional)

» Your comments will be displayed only after manual approval.