代码如下:前者指的是包含自身,后者指的是不包含自身的值,小于等于 与小于
SELECT * FROM blog WHERE ID =(SELECT MAX(ID) FROM blog WHERE created_date <(SELECT created_date FROM blog WHERE ID = #{id})) UNION ALL SELECT * FROM blog WHERE ID =(SELECT MIN(ID) FROM blog WHERE created_date >(SELECT created_date FROM blog WHERE ID = #{id}))