QuestionQ14Verified/Creating Field Aliases and Calculated FieldsCopy linkReport a problemAsk AstroTutorSave questionWhich statement about the coalesce function is correct?AIt can take only a single argument.BIt can take a maximum of two arguments.CIt can be used to create a new field in the results set.DIt can return null or non-null values.Show AnswerAnswerExplanationThe coalesce function can be used in an eval expression to assign a derived field in the results set. It evaluates its arguments in order and returns the first non-null value.Show comments3Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion