原始邮件 发件人:[email protected] 收件人:[email protected] 发送时间:2018年4月20日(周五) 18:38 主题:Error result with this SQL
This SQL result is error. SELECT COUNT(DISTINCT VIEW_TAXI_RIDE.PASSENGER_ID) FROM VIEW_TAXI_RIDE WHERE VIEW_TAXI_RIDE.create_day = '2018-04-10' AND VIEW_TAXI_RIDE.STATUS IN (6,7) AND VIEW_TAXI_RIDE.PASSENGER_ID IN ( SELECT DISTINCT v.PASSENGER_ID FROM view_taxi_ride v WHERE v.create_day = '2018-04-11' AND v.STATUS IN (6,7) ) Bug this SQL result is right. select intersect_count(passenger_id, create_day, array['2018-04-10','2018-04-11']) from VIEW_TAXI_RIDE where STATUS IN (6,7)
