Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- count statement
July 13, 2005, 11:23 am
rate this thread
Re: count statement
I do it in two queries :
select <primarykey>, count(airline) as cnt_airline into temporary table
where OperationType = "Departure"
group by Airline, Runway
HAVING cnt_airline > 5;
from Flight, FLIGHT_GREATER5
where Flight.<primarykey> = FLIGHT_GREATER5.<primarykey>;
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum