order by 与 group by

order by

用来对数据库的一组数据进行排序

　　  desc：降序

　　  asc：升序（默认）

group by

指定的规则对数据进行分组，所谓的分组就是将一个“数据集”划分成若干个“小区域”，然后针对若干个“小区域”进行数据处理。

group by一般用于sum

select name,sum(score) as num from  class group by name

表内容：

SELECT * FROM `radar_record` ORDER BY radar_id,time

SELECT * FROM `radar_record` group BY radar_id       将radar_id分组后取第一个

SELECT * FROM `radar_record` group BY radar_id,time

 

 SELECT
    * 
FROM
    ( SELECT * FROM `radar_record` ORDER BY radar_id, time DESC ) t 
GROUP BY
    t.radar_id 
HAVING
    radar_id = 1

SELECT
    * 
FROM
    ( SELECT * FROM `radar_record` ORDER BY radar_id, time DESC ) t 
GROUP BY
    t.radar_id 

 

  SELECT * FROM `radar_record` ORDER BY radar_id, time DESC