[krodrigues@roku Contributions: 0Level 1☆]

i’m trying to use OVER (PARTITION BY ) in a ODBC SQL statement via SuiteAnalytics Connect. Say I want to rank the Tax Items by state.

SELECT PP.ITEM_ID, RANK() OVER (PARTITION BY PP.TAX_STATE ORDER BY PP.FULL_NAME) RK

FROM

(

SELECT p.ITEM_ID,

p.FULL_NAME,

ROWNUM() AS RN,

p.TAX_STATE

FROM TAX_ITEMS p WHERE P.ISINACTIVE= ‘No’

) PP

I get a ‘Failed to retrieve data’ error rather than the more usual ‘Syntax Error in the SQL statement’ error.

Anyone can help with using RANK and PARTITION?
This is a cached copy. Click here to see the original post.

[Marcus Rangel Contributions: 0Level 1☆]

I’m looking for that too!

Anyone?

[AP.michael.matthews Contributions: 0Level 1☆]

I am seeing this issue as well did either of you find a solution?

[Author]

Posts