title: C# SQL "Syntax error (missing operator) in query expression 'ROW_NUMBER() OVER (ORDER BY CTPoints ASC)"
body: <p>I'm getting a syntax error but I do not know where it is. I'm trying to find the nth row in a table in SQL.</p>
  <p>I am using C# with OleDb as the connection.</p>
  <pre><code>SELECT 
      TName, CTPoints 
  FROM 
      (SELECT 
           ROW_NUMBER() OVER (ORDER BY CTPoints ASC) AS RowNumber, 
           *
       FROM 
           TeamChampionship) AS foo 
  WHERE 
      RowNumber = 1
  </code></pre>
  <p>Any help is appreciated.</p>