本文介绍了获取以前的SQL值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一张桌子,如下图所示。当当前速率值为空时,我想获得先前的速率值。这意味着表中的最后一个比率应该具有值7.6。那可能吗? Valuta汇率Dato EUR 7.5 2014-10-13 EUR 7.9 2014-10-14 EUR 7.6 2014-10-18 EUR 2014-10-20 EUR 2014-10-21
I have a table looking like down below. I would like to get the previously rate value when the current rate value is null. Which mean that the last to rates in the table should have the value 7.6. Is that possible? Valuta rate Dato EUR 7.5 2014-10-13 EUR 7.9 2014-10-14 EUR 7.6 2014-10-18 EUR 2014-10-20 EUR 2014-10-21
推荐答案select top 1 * from table1 where rate is not null order by date desc
更多推荐
获取以前的SQL值
发布评论