
Querying Information in Windows Azure SQL Database ◾ 209
advisors who are not advising the students with the student id 11 or with the student id 12, use
the query in Figure 6.22.
By using IS NULL in the WHERE clause, you can find null values in a given column. e
example in Figure 6.23 finds the null values in the column Grade and selects the corresponding
student ids and class ids.
Be aware that NULL is not equal to 0 or empty space. NULL means unknown.
6.2.3 Comparison Operators
Comparison operators are often used to compare two sets of values. Table 6.3 shows commonly
used comparison operators.
e operators <> and ! = are equivalent. Both are ...