>     select distinct f1 from t1 order by f2;
> 
> Returned the following message under Oracle8 on NT:
>     ORA-01791: not a SELECTed expression

Informix:    309: ORDER BY column (f2) must be in SELECT list. 

Andreas

Thu, 21 Oct 1999 16:48:38 +0200
Zeugswetter Andreas IZ5 <ZeugswetterA@wien.spardat.at>
AW: [HACKERS] distinct. Is this the correct behaviour?
On Thu, 21 Oct 1999, Zeugswetter Andreas IZ5 wrote:

> >     select distinct f1 from t1 order by f2;
> > 
> > Returned the following message under Oracle8 on NT:
> >     ORA-01791: not a SELECTed expression
> 
> Informix:    309: ORDER BY column (f2) must be in SELECT list. 

The version of sybase I tried earlier was 4.9.2.  I just tried it
again on 11.5 -- same thing.

Vince.
-- 
==========================================================================
Vince Vielhaber -- KA8CSH   email: vev@michvhf.com   flame-mail: /dev/null
  # include <std/disclaimers.h>       Have you seen http://www.pop4.net?
        Online Campground Directory    http://www.camping-usa.com
       Online Giftshop Superstore    http://www.cloudninegifts.com
==========================================================================




Thu, 21 Oct 1999 11:09:50 -0400 (EDT)
Vince Vielhaber <vev@michvhf.com>
Re: AW: [HACKERS] distinct. Is this the correct behaviour?