Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

TSQL - SELECT column alias can be used in ORDER BY but not in GROUP BY clause

Aug 26 2011 4:07AM by Pothiraj   

I would like to brush up one of the basic concept. We can use SELECT column alias in ORDER BY clause. But we can't use in GROUP BY clause. The reason is, ORDER BY clause is processed after the SELECT statement; GROUP BY clause is processed before the SELECT statement.

Read More..   [0 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Pothiraj
26 · 6% · 1962
10
 
9
 
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

Your Comment


Sign Up or Login to post a comment.

"TSQL - SELECT column alias can be used in ORDER BY but not in GROUP BY clause" rated 5 out of 5 by 10 readers
TSQL - SELECT column alias can be used in ORDER BY but not in GROUP BY clause , 5.0 out of 5 based on 10 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]