---
title: "SQL查询当前数据上一条和下一条的记录(转)"
author: "javaEEdevelop"
date: "2012-12-14T13:29:41Z"
tags: []
categories: ["数据库"]
slug: "sql"
draft: false
lastmod: "2012-12-14T13:29:41Z"
id: 1747717
url: "https://javaeedevelop.iteye.com/blog/1747717"
---

id是指当前数据news\_id参数

方法一：

string preSql = "select top 1 * from news where news\_id &lt; " + id + " order by news\_id DESC"

string nextSql = "select top 1 * from news where news\_id &gt; " + id + " order by news\_id ASC"

方法二：

string preSql = "select * from \[news] where news\_id = (select MAX(news\_id) from \[news] where news\_id&lt;"+ id + ")";  
string nextSql = "select * from \[news] where news\_id = (select MIN(news\_id) from \[news] where news\_id&gt;"+ id + ")";

转载之(http://ruyu108.blog.163.com/blog/static/101231082010101992117165/)