title: Select subset of rows using Row_Number()
body: <pre><code>Select id, name, ROW_NUMBER() OVER (ORDER BY id asc) as 'RowNo'
  from customers
  where RowNo between 50 AND 60
  </code></pre>
  
  <p>I am trying to select a subset of rows between 50 and 60 . The problem is 'RowNo' is an invalid column name.</p>
  
  <p>Thank you</p>
  
  <p>Using SQL SERVER 2008 R2</p>