SQL根据两行中column1中的值选择一个column2

Question

我有一个这样的表:

To_day     |   percent
-----------------------
  5        |     1.5

  8        |      2

2147483647 |      3 

我想写一个需要一天的 SELECT，在 To_day 列中找到合适的范围并返回相关百分比。例如:

@day = 3 -------> percent = 1.5

@day = 5 -------> percent = 1.5

@day = 7 -------> percent = 2

@day = 15 ------> percent = 3

Answer 1

试试这个:

SELECT TOP 1 [percent]
FROM mytable
WHERE To_day >= @d
ORDER BY to_day