how to select a particular null value from the table containing null values

how to select a particular null value from the ta开发者_StackOverflow社区ble containing null values

---

You can select on the other columns, but of course all NULL values are the same.

---

You can use is null .

For example , select * from tableA where columnA IS NULL will select all the rows from table A which columnA has a null value.