Thread: AW: [HACKERS] distinct. Is this the correct behaviour?
> 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
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 seenhttp://www.pop4.net? Online Campground Directory http://www.camping-usa.com Online Giftshop Superstore http://www.cloudninegifts.com ==========================================================================