| Subject | IB 5.6 / Firebird GROUP BY / ORDER BY Problem |
|---|---|
| Author | nico_callewaert@pandora.be |
| Post date | 2004-04-02T08:56:34Z |
Hi,
I have following group by / order by part of a query :
group by hi_bkj,
hi_drk,
kl_nam
order by hi_bkj,
hi_net desc,
hi_drk
Was working under IB 5.6, now I have the following error :
"Invalid expression in the ORDER BY clause (not contained in either an aggregate function or the GROUP BY clause)"
I understand what the error means, but the problem is I may not group by on field "HI_NET", because then I have too many lines, but I need to sort on that field.
Any idea how to solve it ?
Many thanks in advance,
Nico Callewaert
I have following group by / order by part of a query :
group by hi_bkj,
hi_drk,
kl_nam
order by hi_bkj,
hi_net desc,
hi_drk
Was working under IB 5.6, now I have the following error :
"Invalid expression in the ORDER BY clause (not contained in either an aggregate function or the GROUP BY clause)"
I understand what the error means, but the problem is I may not group by on field "HI_NET", because then I have too many lines, but I need to sort on that field.
Any idea how to solve it ?
Many thanks in advance,
Nico Callewaert