SQL查询Max()最大值对应的记录

详情查看http://blog.csdn.net/bushizhuanjia/article/details/6854208

select id,kind,click_num from code as a   
where  click_num=(select max(b.click_num)  
                  from code as b  
                  where a.kind = b.kind  
                  );