mysql:
select (@i:=@i+1) as i,table_name.* from table_name,(select @i:=0) as it
后面可加order 排序
sql server
第一:
select ROW_NUMBER() OVER (ORDER BY a.字段 ASC) AS XUHAO,a.* from table a
(table 为表名,字段为表a中的字段名)
第二:
select RANK() OVER (ORDER BY a. 字段 ASC) AS XUHAO,a.* from table a(table 为表名,字段为表a中的字段名)