62,271
社区成员
发帖
与我相关
我的任务
分享sql错误:当没有用 EXISTS 引入子查询时，在选择列表中只能指定一个表达式"怎么解决啊?
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')
...全文
请发表友善的回复…
发表回复
阿非 2010-10-08
- 打赏
- 举报
DISTINCT hotel_id,rate_amout
=>
DISTINCT hotel_id
=>
DISTINCT hotel_id
