SQL中 nvl()coalesce()decode()这三个函数是不是递进包含关系?比如:select name,bonus from table where name='apple';name bonus----------------apple 空 (我想让结果=0)以下语句都对吗?如果有问题请指出,1.
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/06 17:58:54
![SQL中 nvl()coalesce()decode()这三个函数是不是递进包含关系?比如:select name,bonus from table where name='apple';name bonus----------------apple 空 (我想让结果=0)以下语句都对吗?如果有问题请指出,1.](/uploads/image/z/5813835-51-5.jpg?t=SQL%E4%B8%AD+nvl%EF%BC%88%EF%BC%89coalesce%EF%BC%88%EF%BC%89decode%EF%BC%88%EF%BC%89%E8%BF%99%E4%B8%89%E4%B8%AA%E5%87%BD%E6%95%B0%E6%98%AF%E4%B8%8D%E6%98%AF%E9%80%92%E8%BF%9B%E5%8C%85%E5%90%AB%E5%85%B3%E7%B3%BB%3F%E6%AF%94%E5%A6%82%EF%BC%9Aselect+name%2Cbonus+from+table+where+name%3D%27apple%27%3Bname+bonus----------------apple+%E7%A9%BA+%EF%BC%88%E6%88%91%E6%83%B3%E8%AE%A9%E7%BB%93%E6%9E%9C%3D0%EF%BC%89%E4%BB%A5%E4%B8%8B%E8%AF%AD%E5%8F%A5%E9%83%BD%E5%AF%B9%E5%90%97%3F%E5%A6%82%E6%9E%9C%E6%9C%89%E9%97%AE%E9%A2%98%E8%AF%B7%E6%8C%87%E5%87%BA%2C1.)
xSnA}kMZ`c4.
- Ǩi֖m%/K33{+8;ԦR
wΙoZ'ؾ +e<0ǃ|2%+HO"Qdj=jc%ZcOxꤐ%/$q:5jxp#%7*o H[:xNmM9 J#-$k7~ `jnw/V#fpۻuAGX]R1@y>U];-H#R4yo˛ͅH?f -s)0`+sݓX'0]$ꖢ,(KP2smT9ڨ-)R,&: @/wMwt@-tLZP%1pR̰Yq?s~m5[Kpx-dryMeۇ(QrH }1Zh.Fe/{EvRdy?ƶ2쎪`.Ehu*q[&.@`>Y&eV\ 0 Z{#EC&q