34,575
社区成员
发帖
与我相关
我的任务
分享
CREATE VIEW
AS
SELECT * FROM
(SELECT col ,
(SELECT COUNT(*) FROM
(SELECT col FROM t1 UNION ALL SELECT col FROM t2) AS A2
WHERE A2.col<A1.col) AS RANK
FROM (SELECT col FROM t1 UNION ALL SELECT col FROM t2) AS A1) AS B
ORDER BY RANK
select *,id = identity(int,1,1) into #tb
from(
select .. from tb1
union all
select .. from tb2
)t