看看这语句select type as name ,max(id)fromM_DefaultValue group by type这个可以select type as name ,
看看这语句
select type as name ,max(id) from M_DefaultValue group by type 这个可以
select type as name ,max(id) as id from M_DefaultValue group by type 这个不行
有什么办法可以返回 name 和id
[解决办法]