Divine Flame (1/28/2015)
True, but then again most people who actually wait for & want to read an interesting article from SSC, will be disappointed after seeing this kind of information as article.First of all, lot of people know this information already.
Second, people who don't know about this, are really not working as SQL Developer or DBA in some serious project (to care for the article).
Just my thought.
I agree, and given that the example used just to demonstrate the need for an alias was a rather poor one; as there was no actual need for the sub-query; perhaps it can best serve as a bad example...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)