oracle 行号由系统自带的rownum伪列实现。mysql要实现此功能稍微麻烦一点。如下
SELECT id,name,(@rowNum:=@rowNum+1) as rowNo FROM Area,(Select (@rowNum :=0) ) b
分页
select * from (SELECT id,name,(@rowNum:=@rowNum+1) as rowNo FROM Area,(Select (@rowNum :=0) ) b) res where rowNo>20 and rowNo<30