Обсуждение: No: implied sort with group by

Поиск
Список
Период
Сортировка

No: implied sort with group by

От
Zeugswetter Andreas DBT
Дата:
> Does the SQL standard say anything about an implied sort when
> grouping or is it up to the user to include an ORDER BY clause?
> darrenk

Without order by the result set is never guaranteed to be ordered in a
specific way (standard speak). The order is dependent on the chosen
query path, which
changes from query to query.

Andreas