mysql 分组取每个组的前几名的问题

select *
from hotel_addition_orders a
where (select count(*)
           from hotel_addition_orders
           where hotel_order_id = a.hotel_order_id and type > a.type)<2
order by a.hotel_order_id asc, a.type desc;
#班级排名----比我分数高的人少于2，那我就排第二名
select *
from hotel_addition_orders where type = 2;



select *
from hotel_addition_orders a
where
  (select count(0) from hotel_addition_orders b where b.hotel_order_id = a.hotel_order_id and type in(1,2,5)) = 3
group by hotel_order_id order by hotel_order_id desc;

转载于:https://www.cnblogs.com/JimmyBright/p/9282512.html