0
Select coalesce(sal ,2)+100 as sal from tablename. What is the meaning of above query
2 ответов
+ 3
coalesce check if sal is null. If It's null, the value 2 is evaluated. Then the result is 102
if sal isn't null is added to 100
+ 2
Furthermore 'sal' probably means salary 😁