Database - Introduction to SQL - Discussion

Discussion Forum : Introduction to SQL - General Questions (Q.No. 12)
12.
Which of the following is the correct order of keywords for SQL SELECT statements?
SELECT, FROM, WHERE
FROM, WHERE, SELECT
WHERE, FROM,SELECT
SELECT,WHERE,FROM
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
7 comments Page 1 of 1.

Myma said:   4 years ago
Exactly (B) is correct.
From ->(tablename).
Where->(filter the records).
Select->(display the filter records).

Vishal Yenge said:   4 years ago
The answer is B because from clause execute first and at last select clause execute.

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

Kiran pandit said:   4 years ago
I think, the correct order is FROM -> WHERE -> GROUP BY -> HAVING -> SELECT -> ORDER.

Jaspreet said:   7 years ago
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.

Bhavin patel said:   9 years ago
Select * From Table name Where this id = this id;

Ashok said:   1 decade ago
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.

SANDEEP said:   1 decade ago
SELECT * FROM CUSTOMER WHERE CUST_ID=1234;

Post your comments here:

Your comments will be displayed after verification.