The following SQL operator can be used to omit records from a search by specifying a not-equal relationship: ____.
A) ALL
B) AND
C) OR
D) NOT

Question

Quizplus · Accepted Answer

The NOT operator in SQL can be used to exclude records that meet a certain condition. For example, if we wanted to search for all employees except for those with a salary of $100,000, we could use the following query: SELECT * FROM employees WHERE salary <> 100000. The <> symbol is the not-equal operator in SQL.

The Following SQL Operator Can Be Used to Omit Records