> valid cases where a subquery can use an ORDER BY, such as when a LIMIT or OFFSET is specified. Oh, quite true! However the output of that subquery, despite h

> valid cases where a subquery can use an ORDER BY, such as when a LIMIT or OFFSET is specified. Oh, quite true! However the output of that subquery, despite having an order by, will not have a guaranteed order. Ordering is lost as the result set leaves the subquery. This is in the sql standard and in most if not all implementations. > I'd go to far to say that unless a query has an ORDER BY it is likely a bug to use LIMIT or OFFSET Wholly agreed.