中考化学实验复习物质的制备、性质.pptVIP

Advanced SQL Murat Kantarcioglu Adapted from Silberchatz et al. slides NULL Values It is possible for tuples to have a null value, denoted by null, for some of their attributes null signifies an unknown value or that a value does not exist. The predicate is null can be used to check for null values. Example: Find all loan number which appear in the loan relation with null values for amount. select loan_number from loan where amount is null NULL Values The result of any arithmetic expression involving null is null Example: 5 + null returns null Any comparison with null returns unknown