在SQL Server表的子集中查找介于前一个值和后一个值之间的值

WITH CTE AS (
  SELECT 
    column1,
    column2,
    ROW_NUMBER() OVER (ORDER BY column1) AS row_number
  FROM your_table
  WHERE condition -- 子集条件
)
SELECT 
  current.column1,
  current.column2
FROM CTE current
JOIN CTE previous ON current.row_number = previous.row_number + 1
JOIN CTE next ON current.row_number = next.row_number - 1
WHERE current.column1 > previous.column1 AND current.column1 < next.column1