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  阅读(122)  评论(0编辑  收藏  举报