in_q,
max(IF(date>100, q, -1)) as min_q,
from a left join b left join c
group by a.p
- Original Message
From: "CRISTEA, Adrian" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Monday, June 9, 2008 9:33:37 AM
Subject: mysql query, min, max with where conditions
Hell
CRISTEA, Adrian schrieb:
Hello there,
What is the corect syntax for selecting something like:
select
a,
b,
(min(q) where date<100),
(max(q) where date>100)
from a left join b left join c
group by a.p
i need min() max() values each of them with other WHERE clause.
How can I do that?
sub sele
Hello there,
What is the corect syntax for selecting something like:
select
a,
b,
(min(q) where date<100),
(max(q) where date>100)
from a left join b left join c
group by a.p
i need min() max() values each of them with other WHERE clause.
How can I do that?
Adrian.
--
MySQL General Mailing L