Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
using DENSE_RANK and PARTITION in SuiteAnalytics Connect (ODBC)
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?
0