sql - 获取第二高的采样日期

Question

我试图获得第二高的样本日期并得到以下错误，请告诉我我在哪里做错了

(SELECT* FROM resheader WHERE sampledate =
   (SELECT MAX(sampleDate) FROM resheader 
      WHERE sampleDate < (SELECT MAX(sampleDate) FROM resheader)
   )
) as 'Previous Sample'

错误

Msg 116, Level 16, State 1, Line 12 Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

Answer 1

在 SQL Server 2012 中，您可以使用 OFFSET FETCH获取第二行的子句(按所需标准排序后):

SELECT * FROM resheader 
ORDER BY sampledate DESC
OFFSET 1 ROWS
FETCH NEXT 1 ROWS ONLY