求一个sql 语句。。。

Question

又碰到版主了。就是ChangeMoneyInfo 里面在@DTime 和@DTimeEnd 时间内，就是第一次充值的人数统计，就是在这个时间段之前是没有记录的。

Answer 1

试试：SELECT  COUNT(DISTINCT UserID)
FROM    ChangeMoneyInfo
WHERE   ChangeTypeID = 1
        AND ChangeTime >= ISNULL(@DTime, ChangeTime)
        AND ChangeTime <= ISNULL(@DTimeEnd, ChangeTime)
HAVING COUNT(DISTINCT UserID)=1

Answer 2

  这个可能不行哦， HAVING COUNT(DISTINCT UserID)=1 这个可能会只是把这段时间内充值了一次的选出来。但是我一个玩家比如当天充值两次，这个估计就会漏掉啊。

Answer 3

  这个可能不行哦， HAVING COUNT(DISTINCT UserID)=1 这个可能会只是把这段时间内充值了一次的选出来。但是我一个玩家比如当天充值两次，这个估计就会漏掉啊。那就去掉distinct

Answer 4

SELECT  COUNT(DISTINCT UserID)
FROM    ChangeMoneyInfo a
WHERE   ChangeTypeID = 1
        AND ChangeTime >= @DTime
        AND ChangeTime <= @DTimeEnd
        AND NOT EXISTS(SELECT 1 FROM ChangeMoneyInfo
                                          WHERE UserID=a.UserID AND ChangeTypeID = 1 AND ChangeTime<@DTime
                                         )

Answer 5

CID         UserID      UserName                                           ChangeTypeID OldMoney              ChangeMoney           UserMoney             Explain                                                                                                                                                                                                                                                    ChangeOrderID ChangeOrderNum                                     PSTypeID    ChangeTime
----------- ----------- -------------------------------------------------- ------------ --------------------- --------------------- --------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------- -------------------------------------------------- ----------- -----------------------
452         66666       dayingjia                                          1            50000.00              100.00                49900.00              下单                                                                                                                                                                                                                                                         160858        20140102035_54b469                                 1           2014-01-02 11:43:18.237
453         66666       dayingjia                                          1            49900.00              100.00                49800.00              下单                                                                                                                                                                                                                                                         160867        20140102036_cdc7f8                                 1           2014-01-02 11:53:16.137
454         66666       dayingjia                                          1            49800.00              126.00                49674.00              下单                                                                                                                                                                                                                                                         160876        20140102036_ef47fa                                 1           2014-01-02 11:53:24.590
455         66666       dayingjia                                          1            49674.00              100.00                49574.00              下单                                                                                                                                                                                                                                                         160885        20140113044_43ce5b                                 1           2014-01-13 13:13:16.997
456         66666       dayingjia                                          1            49574.00              18.00                 49556.00              下单                                                                                                                                                                                                                                                         160894        20140113044_9ee81e                                 1           2014-01-13 13:13:23.813
457         66666       dayingjia                                          1            49556.00              2.00                  49554.00              下单                                                                                                                                                                                                                                                         160903        20140114084_534bde                                 1           2014-01-14 19:52:33.863
458         66666       dayingjia                                          1            49554.00              60.00                 49494.00              下单                                                                                                                                                                                                                                                         160912        20140116035_b96368                                 1           2014-01-16 11:48:18.070
459         66666       dayingjia                                          1            49494.00              60.00                 49434.00              下单                                                                                                                                                                                                                                                         160921        20140116036_784fca                                 1           2014-01-16 11:48:35.110
460         66666       dayingjia                                          1            49434.00              2.00                  49432.00              下单                                                                                                                                                                                                                                                         160930        20140116036_609dd1                                 1           2014-01-16 11:48:45.203
461         66666       dayingjia                                          1            49432.00              2000.00               47432.00              下单                                                                                                                                                                                                                                                         160939        20140116036_33c9d2                                 1           2014-01-16 11:48:56.787
462         66666       dayingjia                                          1            47432.00              1980.00               45452.00              下单                                                                                                                                                                                                                                                         160948        20140116019_a270c0                                 1           2014-01-16 11:49:14.157
466         66666       dayingjia                                          1            45389.00              100.00                45289.00              下单                                                                                                                                                                                                                                                         160957        20140120079_fac516                                 1           2014-01-20 18:59:10.507
467         66666       dayingjia                                          1            45289.00              100.00                45189.00              下单                                                                                                                                                                                                                                                         160966        20140120080_e17e75                                 1           2014-01-20 18:59:10.513
468         66666       dayingjia                                          1            45189.00              100.00                45089.00              下单    

Answer 6

擦，写出来的和11楼的一样SELECT  COUNT(DISTINCT UserID)
FROM    [ChangeMoneyInfo] a
WHERE   ChangeTypeID = 1
        AND NOT EXISTS ( SELECT 1
                         FROM   [ChangeMoneyInfo] b
                         WHERE  b.userid = a.userid
                                AND b.ChangeTypeID = 1
                                AND b.changetime < @DTime )
        AND ChangeTime >= @DTime
        AND ChangeTime <= @DTimeEnd