|
On 10/6/2023 8:48 AM, Dave wrote:
Thanks, I knew I was going to get that reply and I know that the ORDER BY
clause should be added, but that wasn't what I was asking.
There is definitely a difference in behaviour and I think it must be
documented somewhere.
'If the ORDER BY clause is not specified, the rows of the result table
have an arbitrary order.'
https://www.ibm.com/docs/en/i/7.4?topic=subselect-order-by-clause
SQL Reference > Queries > Subselect > order-by-clause
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.