一道SQL面试题

*  文章表:article
    * id,read_num,user_id,content
    * 1,232,2,abc
    * 2,22,2,eee
    * 3,12,1,dfdf
    * 4,44,1,dfe
* 问题:查找 每个作者阅读数最高的 文章id集合

select id from article t1 join (select user_id,max(read_num) from article group by user_id) t2 on(t1.user_id=t2.user_id)
where t1.read_num=t2.read_num