sql语句如下:
select count(*) from mwhbe_hotel_info where 1=1 and hotel_id in
(SELECT DISTINCT hotel_id,rate_amout FROM view_hotel_price WHERE (rate_amout > 700 and rate_amout < 1000))
and is_hotel_status='y' and city_code='SZX' and (rank_code ='5' or rank_code ='5A')
select count(*) from mwhbe_hotel_info where 1=1 and hotel_id in
(SELECT DISTINCT hotel_id,rate_amout FROM view_hotel_price WHERE (rate_amout > 700 and rate_amout < 1000))
and is_hotel_status='y' and city_code='SZX' and (rank_code ='5' or rank_code ='5A')
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货