一句SQL实现类似论坛“上一条”、“下一条”功能！

styxmx

  
   
一句SQL实现类似论坛“上一条”、“下一条”功能！
自己写的，也没有看过其他论坛的相应代码，如果雷同，算我没说。 SELECT art_id AS id, art_title AS title FROM art WHERE (art_id = (SELECT Max(art_id) FROM art WHERE art_id < 120)) UNION ALL SELECT art_id AS id, art_title AS title FROM art WHERE (art_id = (SELECT Min(art_id) FROM art WHERE art_id > 120));