Pergunta de entrevista da empresa Meta

What is 19+NULL in SQL

Respostas da entrevista

Sigiloso

18 de jun. de 2020

Null

Sigiloso

7 de out. de 2020

For Postgres, Redshift & BigQuery: If this is a sum of rows for a column where 1 row is 19 and 1 row is null then the answer is 19. If this is straight up "Select 19 + null" then it's null