This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Does anyone know the correct syntax for window functions in Oracle SQL or do they not allow those like other flavors of SQL?

example
``` Sum(Amount) OVER (Partition By DATE)```

I think you're just missing the curly brackets around the NS fields, like this `Sum{amount} OVER (Partition By {Date})`

<@U54E5RK8Q> I don't think that's quite correct

this is in a SQL IDE, not in NetSuite's UI, so I don't think curly brackets are my answer here

ah ok, that was the syntax to use within Netsuite