DECLARE @T1 table(UserID int , [name] nvarchar(50),num int); insert into @T1 (UserID,[name],num) values (1001,'a',8) insert into @T1 (UserID,[name],num) values (1002,'b',6) insert into @T1 (UserID,[name],num) values (1003,'c',8) insert into @T1 (UserID,[name],num) values (1004,'a',8) insert into @T1 (UserID,[name],num)... |