Discussion :: Introduction to SQL - General Questions (Q.No.12)
|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.
Where->(filter the records).
Select->(display the filter records).
Post your comments here:
Email : (optional)
» Your comments will be displayed only after manual approval.