SELECT ProductName FROM tblProduct WHERE Year BETWEEN year(getdate()+1) AND year(getdate()-1)
不起作用,但类似的东西可能……
SELECT ProductName FROM tblProduct WHERE Year BETWEEN (year(getdate()) -1) AND (year(getdate()) + 1)
