ORDER BY 列名 [DESC | ASC]
参数 | 说明 |
列名 | 列名即为日志字段名称或聚合函数计算结果列 |
DESC | 降序排列 |
ASC | 升序排列 |
* |SELECTstatus,count(*) AS pvGROUP BYstatusORDER BYpv DESC
* | SELECT remote_addr, avg(request_time) as request_time group by remote_addr order by request_time ASC LIMIT 10
本页内容是否解决了您的问题?