GROUP BY ALL, in MySQL
I'm using this query:
select FlTdate Fecha, count(TotBoarded) Vuelos
from transactions
where TxnAmount = 0
and TotBoarded <> 0
and Origin = 'JFK'
group by all FltDate
having FltDate between '2005-10-16' and '2005-10-29'
order by FltDate
But when conditions are not fullfilled, I get an empty row (a.k.a. nothing). But then, I need a zero on that row.
GROUP BY ALL worked, but MySQL doesn't include this function. Any ideas on how to do it?
Thx
Subject
Written By
Posted
GROUP BY ALL, in MySQL
December 13, 2005 10:28AM
December 14, 2005 09:53PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.