Bark interview question
What problems can null values cause in SQL and how to deal with them
Interview Answer
Anonymous
4 Aug 2021
Null inputs cause aggregate functions to result in null outputs. Use nvl, coalesce, or case when statements to fill missing values for aggregation; also for nulls from outer joins