group by的运用

1. select a.* from zeai_photo a inner join (select max(id) mid,userid from zeai_photo group by userid) b on a.userid = b.userid and a.id = b.mid order by a.userid
2. 参考：http://www.cnblogs.com/netserver/p/4518995.html