mysql> select * From (select @rownum:=@rownum+1 as rn,empno,ename from emp,(select @rownum:=0)b limit 1000)a where empno = 7839;
+------+-------+-------+
| rn   | empno | ename |
+------+-------+-------+
|    9 |  7839 | KING  |
+------+-------+-------+
1 row in set, 2 warnings (0.00 sec)



复制

子查询。再套一套就可以了。

select *from 
(
	select @rownum := @rownum + 1 as rowno,oldrowno from
	(
		select 100 oldrowno union all
		select  200 union all
		select 300
		) as t
		,(select @rownum:= 0) as t1
) as t2
where t2.rowno >= 2
复制

rowno oldrowno
2 200
3 300