20 likes | 184 Views
SQL. NULL values. SQL: NULLs. Select A 1 , A 2 ,…, A n From R 1 , R 2 , …, R m Where condition. Demo: simple college admissions database College ( cName , state , enrollment ) Student ( sID , sName , GPA , sizeHS ) Apply ( sID , cName , major , decision ). NULL values:
E N D
SQL NULL values
SQL: NULLs Select A1,A2,…,An From R1,R2, …,Rm Where condition Demo: simple college admissions database College(cName,state,enrollment) Student(sID,sName,GPA,sizeHS) Apply(sID,cName,major,decision) NULL values: undefined or unknown