mysql获取按日期排序获取时间最近的记录

 

      mysql获取按日期排序获取最新的记录

   1. 显示表中全部记录    

     

 

    2. 获取最新时间记录

    利用GROUP BY原理：

select * from (
	select * from gf_mobile_note order by create_time desc
) tem  group by mobile order by create_time desc

   

 

     代码2：

    

-- 获取最新时间记录-利用GROUP BY原理：
select * from (
	select * from gf_mobile_note 
   order by create_time desc
) tem  group by mobile  
    HAVING is_valid=1 AND mobile='18191853680' AND DATE_FORMAT(create_time,'%Y-%m-%d')='2018-07-30'
  order by create_time desc