34,838
社区成员




select id from (select * from mytable) dt
'上面得dt就是一个数据集得名字。
SELECT COUNT(*)
FROM ( SELECT *
FROM ic
WHERE card IN (
SELECT DISTINCT
card
FROM ic
WHERE line_id = '9013'
AND car_id = '79724'
AND time BETWEEN '2017-5-31 00:00:00.000'
AND '2017-05-31 23:59:00.000' )
AND time BETWEEN '2017-5-31 05:00:00.000'
AND '2017-05-31 11:59:00.000'
)t