当前位置: 代码迷 >> Sql Server >> 新增独力用户数
  详细解决方案

新增独力用户数

热度:49   发布时间:2016-04-24 11:01:43.0
新增独立用户数
继续问个问题,

比方说这个表 A           ID       用户名              TIME                         总表B    得到 新用户数
                                    1             aa                     2014.1.1
                                    2             bb                   2014.1.1
                                   3               cc                   2014.1.1                                              3
                                    4              aa                   2014.1.2
                                    5             dd                     2014.1.2                                             1
                                   6                ee                    2014.1.3                                            1
                                   7                 aa                   2014.1.4
                                    8                 ff                     2014.1.4
                                     9                gg                  2014.1.4                                             2
该怎么处理好呢
------解决方案--------------------
/************************************************************
 * Code formatted by SoftTree SQL Assistant ?v6.5.278
 * Time: 2014/4/14 星期一 下午 02:58:35
 ************************************************************/

IF EXISTS(
       SELECT NAME
       FROM   sys.objects AS o
       WHERE  NAME = 'TEST'
  相关解决方案