Sql Server Query:
In Common Tale expression, we extract table column name and give alias to it and using window function in it and try to access that alias in order by clause. But we are unable to access it. can you please suggest me any idea please.