easy5 pts · first answer countssqlnull-handlingstring-functions

Full name comes out empty

In PostgreSQL, customers without a middle name get NULL as their full name from this query. Why?

A.Joining any text with NULL using || gives NULLB.The || operator is only for numbersC.Spaces cannot be joined to text column values with ||D.PostgreSQL drops rows with any NULL column

Discussion 0

Join free to post in the discussion.

Full name comes out empty

Discussion 0

Related questions