当前位置:首页>正文
mysql中怎么解决关于ROW mysql 怎么实现row
2023-06-21 22:42:02 互联网 未知
mysql中怎么解决关于ROW
MySQL要用变量如:
set @row=0
select
*
from
(
select (@row:=@row 1) as RowNum,* from 表--这里加排序用Order by
)as A
SQL Server --Row_Number
Oracle--Row_number/rownum
mysql 怎么实现row
要用变量如:
set @row=0
select
*
from
(
select (@row:=@row 1) as RowNum,* from 表--这里加排序用Order by
)as A
SQL Server --Row_Number
Oracle--Row_number/rownum