04 2016 档案

Sql group by 分组取时间最新的一条数据
摘要：with MiPriceTopOne as (select classid,max(dataTime) dataTime,max(id) as id from MiPrice group by classid)select * from MiPrice where id in (select id 阅读全文
posted @ 2016-04-02 23:19 老皆知 阅读(7879) 评论(0) 推荐(0)