question

Steven Hamoen avatar image
5 Likes"
Steven Hamoen asked Jordan Johnson answered

ROW_NUMBER with or without ()?

I found out that ROW_NUMBER() has a different outcome then ROW_NUMBER. The last one return the row number in the original table, the first one returns the rownumber in the resulting recordset. It is actually pretty nice to have both options, but maybe a good idea to mention that in the helpfile because there both option are written down without the difference:

1643191348369.png

FlexSim 22.0.0
sql queriesrow_number
1643191348369.png (13.0 KiB)
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

·
Jordan Johnson avatar image
1 Like"
Jordan Johnson answered

Yeah, that makes sense. I'll add an issue to the dev list to improve that documentation.

5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.