OLEDB Query Syntax error

[KeerthanaJegann]

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. 

[mkumar407 · Accepted solution]

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]

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]

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