Re: Nested sort, trying again

Vadim Tropashko wrote:
> 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)
> ...

Thanks,

I found it:

SELECT LIST( emp_id ORDER BY emp_lname ) AS "Sorted IDs" FROM EMPLOYEE
GROUP BY dept_id

More elegant, than Oracle's collect.

Yes, it would simplify your example, but would not improve its performance, though ;) Received on Mon Oct 03 2005 - 20:44:49 CDT