每个分类取5条, 这样的SQL如何写

select * from(
select * ,row_number() over(partition by channel_id order by channel_id desc)
as rowindex from dt_article)a
where rowindex<=5

参开地址：http://bbs.csdn.net/topics/220069320