| Subject | Re: [firebird-support] IB 5.6 / Firebird GROUP BY / ORDER BY Problem |
|---|---|
| Author | Elmar Haneke |
| Post date | 2004-04-02T09:44:55Z |
nico_callewaert@... schrieb:
The Group-By does create tuples (hi_bkj,hi_drk,kl_nam) these cannot be
ordered by hi_net since this is undefined (there might be multiple
he_net values associated to each tuple!
As an alternative you might try to sort by "min(hi_net)" or
"max(hi_net)" whatever meets your requirements.
Elmar
> group by hi_bkj,What did IB 5.6 do there?
> hi_drk,
> kl_nam
> order by hi_bkj,
> hi_net desc,
> hi_drk
>
> Was working under IB 5.6
The Group-By does create tuples (hi_bkj,hi_drk,kl_nam) these cannot be
ordered by hi_net since this is undefined (there might be multiple
he_net values associated to each tuple!
As an alternative you might try to sort by "min(hi_net)" or
"max(hi_net)" whatever meets your requirements.
Elmar