mysql 简单查询语句

>=‘2017-04-27‘ and Y_CDATETIME < ‘2017-04-28‘ GROUP BY HOUR;

2、根据查询结果降序排列

SELECT *
FROM(
select DATE_FORMAT(Y_CDATETIME,‘%Y%m%d %H‘) HOUR,count(*) as ‘AA‘
FROM orderdata
GROUP BY HOUR
) t 
ORDER BY t.AA DESC;

 

mysql 简单查询语句

标签：分组   查询   group   div   orm   color   根据   format   order by