Coalesce function in SQL with best examples #sql #shorts #coding #sqlqueries #sqlserver

preview_player
Показать описание
Coalesce function in SQL with best examples #sql #shorts #coding #sqlqueries #sqlserver #youtubeshorts
Рекомендации по теме
Комментарии
Автор

Isnull function also works similar way

gleamofcolor
Автор

Bro, What is the difference between coalesce and NVL?

manndarbar
Автор

Help me with this pls. How can we show in the result to say from which argument was the result pulled for a timestamp field. Like a bracket if the second argument showed the result..like concatenated with ( result) This works for me COALESCE(Min ( 1SCHEMA.TIMESTAMP), 2SCHEMA.TIMESTAMP) but when I tried to concatenate in the 2nd argument I get error for this sql COALESCE(Min ( 1SCHEMA.TIMESTAMP), '('CONCAT CAST(2SCHEMA.TIMESTAMP AS VARCHAR(10) ) CONCAT')')

jonnathanjon
Автор

How to find out null columns in our table

Mahakal