Join Slack
Powered by
Is there a LIMIT in runSuiteQL.query? eg, LIMIT 5
# suitescript
e
eliyahu moskowitz
03/23/2023, 2:28 PM
Is there a LIMIT in runSuiteQL.query? eg, LIMIT 5
s
scottvonduhn
03/23/2023, 2:30 PM
I know these two methods work: SELECT TOP 5 or WHERE ROWNUM <= 5
e
eliyahu moskowitz
03/23/2023, 3:18 PM
THANKS!
j
jen
03/23/2023, 7:58 PM
The limitation which this is that you can’t combine ORDER and TOP unless you do a nested query (that is ordered) and do the TOP in the outer query.
13
Views
Open in Slack
Previous
Next