title: Sql Server Common Table Expression
body: <p>Sql Server Query:</p>
  <p>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.</p>