问题 关于sql查询

[bcy123456]

我要查询数据库表里mm表，查询年龄大于50，我想在查询的结果里加一个序号，如1，2，3...，
如，select name from mm where nl>50
有什么加一个序号，而且序号是顺序的
结果形式是：
1 bcy
2 ldy
3 ml
. .
. .
. .
. .
. .

[realgz]

目前主要有2种方法
1,select * into #tmp from table
alter #tmp add cnt identity(1,1)
select * from #tmp
2,有一个可以唯一区分的列或列组合
select *,(select count(*) from table t2 where t2.id<=t.id) as cnt from table t

[wzh1215]

如果表里有主键：
select (select count(*)+1 from mm a where a.主键>主键 and n1>50) as id,name from mm where n1>50

[zarge]

select identity(int, 1, 1) as sn, name into #tmp from mm where nl>50
select * from #tmp

[realgz]

错了
1,select * into #tmp from table
alter #tmp add cnt int identity(1,1)
select * from #tmp
2,要有一个可以唯一区分的列或列组合
select *,(select count(*) from table t2 where t2.id<=t.id) as cnt from table t

[sdhdy]

select identity(int,1,1) FID,name into #temp from from mm where nl>50
select * from #temp
drop table #temp

[lansquenet]

SELECT identity(int, 1, 1) id, name INTO # FROM mm WHERE nl>50
SELECT * FROM #

[sdhdy]

select identity(int,1,1) FID,name into #temp from mm where nl>50
select * from #temp
drop table #temp

[victorycyz]

select a.name into #A from MM a where a.nl>50
alter table #A add id int identity(1,1)
select * from #A

[dddsdfsd1]

create table #tem(no int identity,name varchar(20))
insert #tem select name from mm where n1>50
select * from #tem
drop table #tem