mysql时间排序获取最新_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