SQL获取上一条下一条数据

--当前条数据
SELECT  * FROM dbo.CRM_MarketingSend  WHERE ID=1135
 --上一条数据
SELECT TOP 1 * FROM dbo.CRM_MarketingSend WHERE id<1135 AND ActionType=0 AND MarketingDataID=330 ORDER BY id DESC
 --下一条数据
SELECT TOP 1* FROM dbo.CRM_MarketingSend WHERE id>1135 AND ActionType=0 AND MarketingDataID=330 ORDER BY id ASC