这个插入新表的语句该怎么写??

xihuluyou 2005-02-02 04:00:56

sql="select distinct a.totalper from allgather as a,userinfo as b where a.uid=b.uid and a.totalField>=20 order by a.totalper DESC"

这一句是求出用户的排名并且按照一定规律返回
返回的结果是这样
100%
90%
80%

现在要把这一句改写成:
求出结果并且排列起来插入到一张新表里,同时要增加一个序列号,新表里的返回结果应该是这样的:
1 100%
2 90%
3 80%

语句该怎么写啊?求教各位

...全文

60 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

lypzl 2005-02-02

打赏
举报

select identity(int,1,1) as id,* into #T
from (select distinct a.totalper from allgather as a,userinfo as b where a.uid=b.uid and a.totalField>=20 order by a.totalper DESC)t

select * from #T

JafyLiu 2005-02-02

打赏
举报

select distinct identity(int,1,1) as id,a.totalper into #t
from allgather as a,userinfo as b
where a.uid=b.uid and a.totalField>=20
order by a.totalper DESC

lengxiaowei 2005-02-02

打赏
举报

create table 新表
(
id int identity(1,1),
totalper varchar(100)
)

insert into 新表(totalper)
select distinct a.totalper from allgather as a,userinfo as b where a.uid=b.uid and a.totalField>=20 order by a.totalper DESC

wxlys 2005-02-02

打赏
举报

同意！

JasonHeung 2005-02-02

打赏
举报

支持

xluzhong 2005-02-02

打赏
举报

select identity(int,1,1) as id,* into ##T
from (select distinct a.totalper from allgather as a,userinfo as b where a.uid=b.uid and a.totalField>=20 order by a.totalper DESC)t

select * from ##T

# 高阶 DML 操作将查询结果插入到新表（相当于表复制功能）根据另一张表的条件，更改本表记录根据另一张表的条件，删除本表记录 ------------------------------------------------------------- ...