topic Re: Not Applicable in Application Development and Automation Discussions

Not Applicable

former_member775888 — Thu, 28 Oct 2021 13:04:05 GMT

Re: Not Applicable

Dominik_Tylczynski — Thu, 28 Oct 2021 13:29:53 GMT

Hello cjojo

Unless you use ORDER BY, the result of a SELECT statement is not defined - see SAP Help SELECT:

If the addition ORDER BY is not used, the order of the rows in the results set is not defined and, if the same statement SELECT is executed multiple times, the order may be different each time.

So, what you see is not surprising.

You must not rely on the sequence of SELECT result if don't use ORDER BY or if you don't sort the result on the application side.

Best regards

Dominik Tylczynski

Re: Not Applicable

matt — Fri, 29 Oct 2021 03:47:11 GMT

(Don't post QUESTIONS as ANSWERS, please! - read that bit next to the "Your answer" edit box, labelled "Before answering".

Randomly display. That's what Dominik means by Unless you use ORDER BY, the result of a SELECT statement is not defined and You must not rely on the sequence of SELECT result if don't use ORDER BY or if you don't sort the result on the application side.

This is something than many people seem to have missed in their IT education! With relational databases (i.e. every database used with SAP) there is no sort order. The order is undefined.

Re: Not Applicable

matt — Fri, 29 Oct 2021 09:58:13 GMT

It seems that many people's IT education doesn't include that by definition relational databases do not have a default sort order.