| Subject | Re: [firebird-support] Possible bug with GROUP BY and UNION |
|---|---|
| Author | Nick Upson |
| Post date | 2004-07-12T16:18:41Z |
Does "UNION ALL" instead of UNION give the result you expect
In article <000001c4681b$75bef0f0$0b00a8c0@t2450>, Salim Naufal wrote:
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly
In article <000001c4681b$75bef0f0$0b00a8c0@t2450>, Salim Naufal wrote:
> SELECT SUM(AMOUNT)--
> FROM TBL
> WHERE TYPE_OF_ROW = 0
> GROUP BY TYPE_OF_ROW
> UNION
> SELECT AMOUNT
> FROM TBL
> WHERE TYPE_OF_ROW <> 0
>
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly