This blog is about the simple solutions I found during my daily programming duties with a hope that somebody can use it to solve their similar problems. Or may be someone can suggest us a better solution for the same.
May 19, 2010
Compare NULL values in SQL Query
You can compare NULL values using "IS NULL" after the field name of a table.
SELECT id, name, city, zip FROM tableStudent WHERE city IS NULL
No comments:
Post a Comment