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

Filed under:

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

Related posts about mysql