Ad
  • Default User Avatar

    tldr: U can't say that table is ordered, or the result is ordered(unless it's specified to order it).

    You can always order finite set, as ordering require relation, and it is always possible to make relation between all objects in finite set.
    Set of possible relations between elements of finite amount of sets is a carthesian product of those finite amount of sets,
    relation is element of this set. In this case, we can simply tell that any result is ordered by relation x1x2...xn-1xn, where x~y means x is in relation with y.

    More, ordering in sql makes preassumption that we want order result by '>' relation, or '<' in case of descending.
    However, if we don't specify ordering, result of query should be treated as SET, same as tables in database, which means result is always UNORDERED (Disordered? It sounds like it has mental problems :D) unless we specify to order it somehow.

  • Default User Avatar

    afaik y is a vowel