CREATE TABLE [dbo].[tb6](
[a] [varchar](5) NULL,
[b] [varchar](5) NULL
) ON [PRIMARY]
insert into tb6 values('a',null)
insert into tb6 values('a',null)
insert into tb6 values('b',null)
insert into tb6 values('b',null)
insert into tb6 values('b',null)
insert into tb6 values('c',null)
insert into tb6 values('c',null)
CREATE TABLE [dbo].[tb7](
[a] [varchar](5) NULL,
[b] [varchar](5) NULL
) ON [PRIMARY]
insert into tb7 select a,b=row_number()over(order by a) from tb6
select * from tb7
select *,COUNT(*) from tb7 group by a,b
[a] [varchar](5) NULL,
[b] [varchar](5) NULL
) ON [PRIMARY]
insert into tb6 values('a',null)
insert into tb6 values('a',null)
insert into tb6 values('b',null)
insert into tb6 values('b',null)
insert into tb6 values('b',null)
insert into tb6 values('c',null)
insert into tb6 values('c',null)
CREATE TABLE [dbo].[tb7](
[a] [varchar](5) NULL,
[b] [varchar](5) NULL
) ON [PRIMARY]
insert into tb7 select a,b=row_number()over(order by a) from tb6
select * from tb7
select *,COUNT(*) from tb7 group by a,b