Wednesday, 7 December 2016

Why are you not allowed to refer to a column alias defined by the SELECT clause in the WHERE clause?

You not allowed to refer to a column alias defined by the SELECT clause in the WHERE clause, because the WHERE clause is logically evaluated in a phase earlier to the one that evaluates the SELECT clause.

This is the reason that below statement will not work: 


Visit Our New Site for HR Interview Questions Answers http://www.interviewboat.com/Company/GetCompany
Sponsored Ads

0 comments:

Post a Comment