C# SQL "Syntax error (missing operator) in query expression 'ROW_NUMBER() OVER (ORDER BY CTPoints ASC)"

Asked Dec 18 '21 at 22:05

Active Dec 19 '21 at 06:13

Viewed 60 times

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.

I am using C# with OleDb as the connection.

SELECT 
    TName, CTPoints 
FROM 
    (SELECT 
         ROW_NUMBER() OVER (ORDER BY CTPoints ASC) AS RowNumber, 
         *
     FROM 
         TeamChampionship) AS foo 
WHERE 
    RowNumber = 1

Any help is appreciated.

edited Dec 19 '21 at 06:13

marc_s

704,970
168
1,303
1,425

asked Dec 18 '21 at 22:05

Nickksz

3

That error message seems like you are using Access? That doesn't support `ROW_NUMBER` – Martin Smith Dec 18 '21 at 22:12
Possible duplicate https://stackoverflow.com/q/14683226/73226 - though seems you should just use `top 1` as you don't need the numbering – Martin Smith Dec 18 '21 at 22:13
You're not partitioning your rows so you just need an *order by* criteria here. – Stu Dec 18 '21 at 22:24
Oof, I think you've reached the point where a database upgrade is in order.. – Caius Jard Dec 19 '21 at 07:49

C# SQL "Syntax error (missing operator) in query expression 'ROW_NUMBER() OVER (ORDER BY CTPoints ASC)"

0 Answers0