转载地址 下一条 select t1.* from ( -- 查询数据添加序号列 SELECT @num:=@num+1 AS rownum, holiday.* FROM holiday,(SELECT @num:=0) as r ORDER BY cr_date )t1,( -- 查询当前记录对应序号 select curNum from( SELECT @num2:=@num2+1 AS curNum, holiday.* FROM holiday ,(SELECT @num2:=0) r2 ORDER BY cr_date )t where id=5014 )t2 where rownum > curNum ORDER BY rownum 上一条 select t1.* from ( -- 查询数据添加序号列 SELECT @num:=@num+1 AS rownum, holiday.* FROM holiday,(SELECT @num:=0) as r ORDER BY date )t1,( -- 查询当前记录对应序号 select curNum from( SELECT @num2:=@num2+1 AS curNum, holiday.* FROM holiday ,(SELECT @num2:=0) r2 ORDER BY date )t where id=5014 )t2 where rownum < curNum ORDER BY rownum desc limit 1