SQL 加序号(行号)

来源:互联网 发布:ubuntu更改文件夹权限 编辑:程序博客网 时间:2024/04/29 14:26

Oracle :

row_number over(order by code)

SQLServer2000:

select ( select count(*)            from   table_name  p1            where  p1.id<= p2.id)  as rowNumber,* from table_name  p2order by rowNumber

SQLServer2005+:

 Row_number()


MySQL:

@ i = @ i +1

 SELECT @i := @i + 1 uindex,t.name            FROM (SELECT @i := -1) AS i,table_name t


0 0
原创粉丝点击