你好 tankin,
关于您的这个问题,我们只需row_number()这个函数就可以实现,测试代码如下:
CREATE TABLE INDATE
(INDATE NVARCHAR(20),
NAME NVARCHAR(20))
GO
INSERT INTO INDATE
VALUES ('2011\05\01','A')
INSERT INTO INDATE
VALUES ('2011\05\01','B')
INSERT INTO INDATE
VALUES ('2011\05\02','A')
INSERT INTO INDATE
VALUES ('2011\05\02','B')
INSERT INTO INDATE
VALUES ('2011\05\02','C')
INSERT INTO INDATE
VALUES ('2011\05\03','A')
INSERT INTO INDATE
VALUES ('2011\05\03','B')
GO
SELECT INDATE,NAME,ROW_NUMBER() OVER(PARTITION BY INDATE ORDER BY INDATE,NAME)AS COUNT1
FROM INDATE
GO
Thanks,
Weilin Qiao
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.