SQL语句实现在某时间段内按某个别字段(并不是所有字段)筛选掉重复的记录,只留下最近时间的记录;再把筛选后的数据按时间降序排列输出结果
select * from qiandao_T where date in(select max(date) from 表名where date between '开始日期'
and '结束日期' group by 字段名)order by date desc
select * from qiandao_T where date in(select max(date) from 表名where date between '开始日期'
and '结束日期' group by 字段名)order by date desc