Jay wrote:
May I ask, are you a lawyer?OK, there is no requirement, but there is a wish to return a stable
sorting outcome.
Just add an 'order by' clause.
Please note that the SQL standard does not prohibid stable sorting
outcome.
It does prohibit it. It states the output is not sorted unless you ask for it to be.
It does not say, give the resultset randomized if two sort-arguments are the same.
Here you have a good point, you can always do that, and it saves processor cycles for not adding the rowid unasked.
Please also note that by adding the rowid an unstable sort-algorithm
can produce a stable sort-outcome.
Add an 'order by' clause and a rowid to your select.
regards Bert Verhees
