mysql如何每个分类取最新一条数据

现有如下数据

type time

2 2014-07-12
2 2014-08-14
3 2014-08-10
4 2014-08-03
4 2014-08-11
1 2014-08-12
1 2014-07-13
1 2014-08-15
要取出如下数据，按照type升幂，time降幂

type time
1 2014-08-15
2 2014-08-14
3 2014-08-10
4 2014-08-11
sql语句怎样写最简单快捷

举报该问题

其他回答

第1个回答 2014-08-12

先排序再用 group by 取

假设 table xxx

select * from
(select * from xxx order by time desc ) a
group by type
order by type本回答被提问者采纳

相似回答

mysql update指定分类取最新的3条数据更新答：分析，查询出了每一种city_id的数量,select count(*) count,city_id from table1 group by city_id 查询出数量等于3的city_id select city_id from(select count(*) count,city_id from table1 group by city_id ) s where s.count=3 对这个数量等于3的yz进行修改 update table1 set yz=...

mysql查询结果中,有多条不同数据但其中多个字段值会相同的记录想取其中...答：select max(id),elec_id,model_info_id from 表 group by elec_id,model_info_id

mysql每个分类依次读取一条记录的问题,详见图片答：1 显示器 2 CPU 3 硬盘 / sqlstr = "select * from category order by cid";query = @mysql_query($sqlstr) or die(mysql_error());while($thread=mysql_fetch_array($query)){//获取一共有多少个分类 cgroup[] = $thread;} result = array();total = array();for($i=0...

大家正在搜