摘要：select * from(select animal,age,id,row_number()over(partition by animal order by age desc) row_numfrom zoo)where row_num <=5;http://bbs.csdn.net/topic... 阅读全文