| Subject | RE: [ib-support] Order By within Subselect? |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2003-05-24T10:23:31Z |
Alan,
case SELECT FIRST 1 ... ORDER BY ... can be much more efficient than
aggregates or SPs. Especially given the fact that you may order by different
columns from the ones used in the select list.
Dmitry
> but the subselect needs to be a singleton anyway doesn't it?It must be a singleton only if used in the select list. And even in this
> what's the use of an order by clause?
case SELECT FIRST 1 ... ORDER BY ... can be much more efficient than
aggregates or SPs. Especially given the fact that you may order by different
columns from the ones used in the select list.
Dmitry