表联合查询序号不相连的问题。。急

[xiongjiahui288]

例如：
select * into #TempTable from
(
select row_number() over(order by A.ID)as rowNumber, *
union All
select row_number() over(order by B.ID)as rowNumber, *
)T

然后分页查询出 #TempTable
我希望的结果是：
1 ...
2 ...
3 ...
4 ...

但是结果是：
1 ...
2 ...
1 ...
2 ...

应该怎么改呢？？求助。。。

[Mr_Nice]

over (partition by 要分组的字段 order by ID )

添加partition by

[水族杰纶]

select row_number() over(order by ID)as rowNumber,* into #TempTable from  
(
  select  * from ta
  union All
  select  * from tb
)T

[永生天地]

select row_number() over(partition by xxx order by A.ID)as rowNumber, *

[guguda2008]

select INENTITY(INT,1,1) as rowNumber,* into #TempTable from 
(
  select  * FROM A
  union All
  select  * FROM B
)T

[xiongjiahui288]

[Quote=引用 2 楼 wufeng4552 的回复:]
SQL code
select row_number() over(order by ID)as rowNumber,* into #TempTable from
(
select * from ta
union All
select * from tb
)T
[/Quote]

那个ID无效啊。。

[水族杰纶]

[Quote=引用 5 楼 xiongjiahui288 的回复:]
引用 2 楼 wufeng4552 的回复:
SQL code
select row_number() over(order by ID)as rowNumber,* into #TempTable from
(
select * from ta
union All
select * from tb
)T


那个ID无效啊。。
[/Quote]

select row_number() over(order by(select 1))as rowNumber,* into #TempTable from  
(
  select  * from ta
  union All
  select  * from tb
)T

[xiongjiahui288]

[Quote=引用 6 楼 wufeng4552 的回复:]
引用 5 楼 xiongjiahui288 的回复:
引用 2 楼 wufeng4552 的回复:
SQL code
select row_number() over(order by ID)as rowNumber,* into #TempTable from
(
select * from ta
union All
select * from tb
)T


那个ID无效……
[/Quote]


非常感谢，结贴。。。

[guguda2008]

多少给点分吧