cancel
Showing results for 
Search instead for 
Did you mean: 

OLEDB Query Syntax error

KeerthanaJegann
Level 4
I just used a query for SELECT [first_name], [last_name],  RANK() OVER ( PARTITION BY [department_id] ORDER BY [salary]) [salary_rank] FROM [employees$] - but when i run this query using OLEDB VBO- i get this error - 

": Syntax error (missing operator) in query expression 'RANK() OVER ( PARTITION BY [department_id] ORDER BY [salary]) [salary_rank]"


Not sure, what is the syntax error. Can someone please help me with it. 
1 BEST ANSWER

Helpful Answers

mkumar407
Level 7
Hey,

Can you check SQL compatible syntax for your database. If connecting to Access it might be ANSI-92 and RANK is not supported in ANSI-92.

View answer in original post

3 REPLIES 3

mkumar407
Level 7
Hey,

Can you check SQL compatible syntax for your database. If connecting to Access it might be ANSI-92 and RANK is not supported in ANSI-92.

KeerthanaJegann
Level 4
Hello,

Thanks for the reply. Yes I am connecting to Database engine. How can I check the SQL compatible syntax? And I am not sure what are the queries I could really use using OLEDB VBO. Do we have any documentation for it? Thanks!

EmersonF
MVP

@KeerthanaJegan1,
See if it helps you in any way​
​http://community.blueprism.com/HigherLogic/System/DownloadDocumentFile.ashx?DocumentFileKey=56f3f77f-6c92-4a75-9e66-0b0ed2f6e054

Sr Cons at Avanade Brazil