mysql取前取后

SELECT * FROM (SELECT * FROM 表 WHERE id<居中的ID ORDER BY id DESC LIMIT 5) as A
UNION all
SELECT * FROM (SELECT * FROM  表 WHERE id >=居中的ID ORDER BY id ASC LIMIT 5) as B
order by  id asc
posted @ 2014-05-16 13:21  mali0932  阅读(141)  评论(0)    收藏  举报