|
|
|
|
|
|
by throwaway_pdp09
2061 days ago
|
|
|
> 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. |
|
|