如何查询记录中数值在某个范围内的那个点的记录？

Question

测试数据奉上 
with tb(TimePoint,TempValue,PF)as(
select 20131201080100,20.02,0.2 union 
select 20131201080105,27.33,1.2 union
select 20131201080110,31.36,1.4union
select 20131201080115,32.00,1.8union
select 20131201080120,28.59,0.2 union
select 20131201080125,50.26,1.4union
select 20131201080130,20.34,1.6union
select 20131201080135,40.18,1.5union
select 20131201080140,35.00,1.0  union
select 20131201080145,20.21,0.2union
select 20131201080150,20.54,0.2union
select 20131201080155,31.22,0.9 )
select * from tb

Answer 1

with tb(TimePoint,TempValue,PF)as(
select 20131201080100,20.02,0.2 union 
select 20131201080105,27.33,1.2 union
select 20131201080110,31.36,1.4union
select 20131201080115,32.00,1.8union
select 20131201080120,28.59,0.2 union
select 20131201080125,50.26,0.4union
select 20131201080130,20.34,1.6union
select 20131201080135,40.18,1.5union
select 20131201080140,35.00,1.0  union
select 20131201080145,20.21,0.2union
select 20131201080150,20.54,0.2union
select 20131201080155,31.22,0.9 )
select * from tb

Answer 2

20131201080135       40.18              1.5 
还是没太看懂。这条的 PF 在 1.0-2.0之间  但是TempValue 不在 30.00-40.00 之间 ，
为什么也是开呢？