如何处理null.pptVIP

如何处理null null是一个常量，仅在数值和字符串类型的列中有意义，代表的是没有意义或者是不确定的值。例如，学生选了课程，当成绩没有出来时grade字段的值应该为空；或者工资表中一个行政人员在课时补贴一栏的值为null，因为它不可能有课时补贴的收入 Null Values The result of any arithmetic expression involving null is null. Aggregate functions simply ignore null values Is an arbitrary decision. Could have returned null as result instead. We follow the semantics of SQL in its handling of null values For duplicate elimination and grouping, null is treated like any other value, and two nulls are assumed to be the same Alternative: assume each null is different from each other Both are arbitrary decisions, so we simply follow SQL is null的结果为true 用ORDER BY子句对查询结果按成绩排序时，若按升序排，成绩为空值的元组将最后显示，若按降序排，成绩为空值的元组将最先显示。 Three-valued logic using the truth value unknown: Comparisons with null values return the special truth value unknown If false was used instead of unknown, then not (A 5) would not be equivalent to A = 5 选择时仅使条件表达式的结果为True的元组选取出来 * * * * * *