On 7 November 2012 08:27, YAN HONG YE <yanhong...@mpsa.com> wrote: > SELECT * FROM ADL WHERE Project_grading is null; > can't select anything.
sqlite> create table ADL( id integer primary key, data text, Project_grading integer ); sqlite> insert into ADL( data, Project_grading ) values( '1', 1 ); sqlite> insert into ADL( data, Project_grading ) values( '2', 2 ); sqlite> insert into ADL( data ) values( '3' ); sqlite> insert into ADL( data, Project_grading ) values( '4', 4 ); sqlite> insert into ADL( data ) values( '5' ); sqlite> insert into ADL( data, Project_grading ) values( '6', 6 ); sqlite> sqlite> select * from ADL; 1|1|1 2|2|2 3|3| 4|4|4 5|5| 6|6|6 sqlite> sqlite> select * from ADL where Project_grading is null; 3|3| 5|5| Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
