sql语法错误

[qq_38487638]

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')

错误提示：[S0001][102] “)”附近有语法错误。
求解答

[二月十六]

加个别名

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

[听雨停了]

正解，别名没有

[Dogfish]

如果要在一个数据集选择，要先要给个名字给这个数据集，然后才能想table一样使用。

select id from (select * from mytable) dt
'上面得dt就是一个数据集得名字。