例如TableA id name 1 abc 2 def 3 ghi 4 jkl 5 mno 6 pqr查出id 3 的上下两个纪录会查出 id 1-5的纪录
select * from ( select * from qwe where id<=3 order by id desc limit 1,2) b union select * from ( select * from qwe where id>=3 order by id desc limit 1,2) a order by id orselect * from ( select * from qwe where id<3 order by id desc limit 0,2) b union select * from ( select * from qwe where id>3 order by id desc limit 0,2) a order by id
select * from TableA where id <=3 order by id desc limit 3 union select * from TableA where id >3 order by id desc limit 2
or select * from ( select * from qwe where id <3 order by id desc limit 2) b union select * from ( select * from qwe where id>3 order by id desc limit 2) a order by id
id name
1 abc
2 def
3 ghi
4 jkl
5 mno
6 pqr查出id 3 的上下两个纪录会查出 id 1-5的纪录
select * from qwe where id<=3 order by id desc limit 1,2) b
union
select * from (
select * from qwe where id>=3 order by id desc limit 1,2) a
order by id orselect * from (
select * from qwe where id<3 order by id desc limit 0,2) b
union
select * from (
select * from qwe where id>3 order by id desc limit 0,2) a
order by id
union
select * from TableA where id >3 order by id desc limit 2
select * from (
select * from qwe where id <3 order by id desc limit 2) b
union
select * from (
select * from qwe where id>3 order by id desc limit 2) a
order by id