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