看看这语句解决办法

2012-03-09

看看这语句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

[解决办法]