-syntax error (missing operator) in query expression 'row_number() over (order by RunTime)'

Question

1.00/5 (1 vote)

See more:

Everytime I run this SQL it says
-syntax error (missing operator) in query expression 'row_number() over (order by RunTime)'

Table Name:EventsDetail
Columns: MemberID, EventNumber, RUnTime

adoqueryAdmin.SQL.Text:=Select EventNumber,MemberID, RunTime, ROW_NUMBER() OVER (ORDER BY RunTime) AS Place from EventsDetail where EventNumber=''AAA001'' order by RunTime'

How do I solve it?

Posted 5-Oct-14 21:28pm

SWStander

Add a Solution

Comments

JR009 6-Oct-14 3:38am

I think, you are using order by clause two times in query that's why error occurs.
Try to remove order clause from last in query then run it.

Schatak 6-Oct-14 3:51am

by writing order by two times doesn't cause this issue.
Issue can be with your syntax in writing colon signs. can you please share your code how you are writing?

Herman<T>.Instance 6-Oct-14 6:26am

have you tried:
Select EventNumber,MemberID, RunTime, ROW_NUMBER() OVER (PARTITION BY runtime ORDER BY RunTime) AS Place from EventsDetail where EventNumber=''AAA001'' ?

Kornfeld Eliyahu Peter 6-Oct-14 6:57am

What version of SQL do you using?

Maciej Los 6-Oct-14 13:53pm

Have a look at the beginning of statement. You missed (') before SELECT.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

vangapally Naveen Kumar · Answer 1 · 2014-10-06T19:25:00

try like this

SQL

declare @Test Table
(
id int identity(1,1),
number int,
runtime time
)
insert into @Test values(1,'17:32:19')
insert into @Test values(2,'17:33:22')
insert into @Test values(3,'17:32:20')

Select Number,ID, runtime, ROW_NUMBER() OVER (ORDER BY runtime) AS Place
 from @TEST where Number='1' order by runtime

its working fine.

-syntax error (missing operator) in query expression 'row_number() over (order by RunTime)'

1 solution

Solution 1

Add your solution here

Preview 0

-syntax error (missing operator) in query expression 'row_number() over (order by RunTime)'

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us