View Single Post
Old 04-08-2011, 01:32 PM   #8
Arsenal14
Powerplay Quarterback
 
Arsenal14's Avatar
 
Join Date: Aug 2005
Exp:
Default

"AS" just names the column when you select an expression (or can be used to rename a column in the result set). So you could do "select a, b, a-b as c from foo" and the result set would contain 3 columns called a, b, c with c being the difference between a and b.
Arsenal14 is offline   Reply With Quote