Sqlserver 查詢指定記錄前后N條，包括當(dāng)前數(shù)據(jù)

條件 【ID】

查詢 【N】條

select * from [Table] where ID in (select top (【N】+1) ID from[Table] where id <=【ID】 order by id descunionselect top 【N】 ID from[Table] where id>【ID】 order by id )order by ID

例如：有數(shù)據(jù)表 A

id name datet1 123123 2015-08-04 11:19:32.7703 qwerqwer 2015-08-04 11:19:34.7104 qwerqfsd 2015-08-04 11:19:35.5077 jhndf 2015-08-04 11:19:38.5078 sdfsdfc 2015-08-04 11:19:39.72010 asdfsvc 2015-08-04 11:19:42.89712 gdfvasdf 2015-08-04 11:19:44.92713 vwrt4g 2015-08-04 11:19:46.51715 asdvsdfg 2015-08-04 11:19:52.150

查詢ID 為8的前后2條數(shù)據(jù)

SQL 語句為：

select * from A where ID in (select top 3 ID from A where id <=8 order by id descunionselect top 2 ID from A where id>8 order by id )order by ID

結(jié)果：

id name datet4 qwerqfsd 2015-08-04 11:19:35.5077 jhndf 2015-08-04 11:19:38.5078 sdfsdfc 2015-08-04 11:19:39.72010 asdfsvc 2015-08-04 11:19:42.89712 gdfvasdf 2015-08-04 11:19:44.927

結(jié)束~~~~，大牛勿噴，主要記錄一下，自己用。