- #1
- 7,327
- 11,169
Hi All,
I am doing a query in which I am ALIASING a column name, say 'column name' AS x
Can I , at the end of the query ORDER BY x, or must I ORDER BY the given initial 'column name'?
(Still having trouble downloading free copy of MSSQL2012, so I cannot test the query).
I know this has to see with when the Alias is 'computed' in the query, but I am having trouble still.
Thanks.
I am doing a query in which I am ALIASING a column name, say 'column name' AS x
Can I , at the end of the query ORDER BY x, or must I ORDER BY the given initial 'column name'?
(Still having trouble downloading free copy of MSSQL2012, so I cannot test the query).
I know this has to see with when the Alias is 'computed' in the query, but I am having trouble still.
Thanks.