Re: Distinct in query results in wrong order by

andrewst <member14183_at_dbforums.com> wrote in message news:<3025538.1056119826_at_dbforums.com>...
> Originally posted by Sal
> > Competitor DBMS products allow you to sort by any column to like,
> > whether in the select list or not.
> >
> >
> > Sal
> Do they? So given this table T:
>
> A B
> - -
> 1 1
> 1 2
> 2 1
> 2 2
>
> What would be the result of:
>
> select distinct a
> from t
> order by b;
>
> In what sense could the result be "ordered by b"?

Good point. Didn't read question properly, 0/10, back to school. Received on Tue Jun 24 2003 - 00:26:38 CEST