随笔分类 -  SQL SERVER

SQL查询当前数据上一条和下一条的记录
摘要：id是指当前数据news_id参数方法一：stringpreSql = "select top 1 * from news where news_id< "+id+" order by news_idDESC"stringnextSql = "select top 1 * from news where news_id> "+id+" order by news_idASC"方法二：s... 阅读全文
posted @ 2010-08-07 03:21 NetGao 阅读(3185) 评论(1) 推荐(1)