本文介绍了SQL查询,如果值为空则返回1的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个查询返回我们系统中设置的汇率值.并非每个订单都有汇率 (currate.currentrate),因此它返回空值.
I have a query that is returning the exchange rate value set up in our system. Not every order will have an exchange rate (currate.currentrate) so it is returning null values.
我可以让它返回 1 而不是 null 吗?
Can I get it to return 1 instead of null?
可能类似于 if 语句:
Something like an if statement maybe:
if isnull(currate.currentrate) then 1 else currate.currentrate下面是我的查询.我非常感谢您的所有帮助!
Here is my query below. I greatly appreciate all your help!
SELECT orderhed.ordernum, orderhed.orderdate, currrate.currencycode, currrate.currentrate FROM orderhed LEFT OUTER JOIN currrate ON orderhedpany = currratepany AND orderhed.orderdate = currrate.effectivedate 推荐答案您可以使用 CASE 语句.
SELECT CASE WHEN currate.currentrate IS NULL THEN 1 ELSE currate.currentrate END FROM ...更多推荐
SQL查询,如果值为空则返回1
发布评论