question about group by
Posted
by chun
on Stack Overflow
See other posts from Stack Overflow
or by chun
Published on 2010-05-18T13:45:51Z
Indexed on
2010/05/18
13:50 UTC
Read the original article
Hit count: 235
mysql
Hi
in mysql how to write a sql like this, to get the amount of X > 20 and <20
select date, numberOfXMoreThan20,numberOfXLessThan20, otherValues
from table
group by (date, X>20 and X<20)
thanks
© Stack Overflow or respective owner