Re: Distinct in query results in wrong order by
From: andrewst <member14183_at_dbforums.com>
Date: Fri, 20 Jun 2003 14:37:06 +0000
Message-ID: <3025538.1056119826_at_dbforums.com>
Date: Fri, 20 Jun 2003 14:37:06 +0000
Message-ID: <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"?
-- Posted via http://dbforums.comReceived on Fri Jun 20 2003 - 16:37:06 CEST