Re: Nested sort, trying again
From: Vadim Tropashko <vadimtro_invalid_at_yahoo.com>
Date: 3 Oct 2005 17:32:54 -0700
Message-ID: <1128385974.431931.140940_at_f14g2000cwb.googlegroups.com>
Date: 3 Oct 2005 17:32:54 -0700
Message-ID: <1128385974.431931.140940_at_f14g2000cwb.googlegroups.com>
vc wrote:
> >
> > Either way, there is little sence elaborating this idea in oracle, as
> > the OP is evidently using some other RDBMS. If it's sybase anywhere, or
> > mysql, then ordering should be already taken care of in the syntax.
>
> Could you elaborate on those two ?
I lost the reference to Sybase LIST aggregate function definition, but remember that it admits "order by" clause like this
select deptno, LIST(ename order by sal)
...
Received on Tue Oct 04 2005 - 02:32:54 CEST