使用SQL語句查詢某記錄的前後N條資料

標籤：des   style   blog   color   io   使用   strong   資料   div   

id是指當前資料tb_id參數

方法一：

string preSql = "select top 1 * from table where tb_id < " + id + " order by tb_id DESC"string nextSql = "select top 1 * from table where tb_id > " + id + " order by tb_id ASC"

方法二：

string preSql = "select * from [table] where tb_id = (select MAX(tb_id) from [table] where tb_id<"+ id + ")";string nextSql = "select * from [table] where tb_id = (select MIN(tb_id) from [table] where tb_id>"+ id + ")";

將查詢結果union即可。

使用SQL語句查詢某記錄的前後N條資料