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@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 Mon Oct 03 2005 - 19:32:54 CDT