SELECT id, name, city, zip FROM tableStudent WHERE city IS NULL
Showing posts with label IS NULL. Show all posts
Showing posts with label IS NULL. Show all posts
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
SELECT id, name, city, zip FROM tableStudent WHERE city IS NULL
Subscribe to:
Posts (Atom)