取一个表中每个类别取十个数据

select shop_name,typeid from
(SELECT dy_shopinfo.*,dense_rank() over(PARTITION BY typeid ORDER BY shopid DESC) v FROM dy_shopinfo)
where v<=10