NOT
NOT returns rows that do not satisfy a condition.
Syntax
NOT expression
NOT expression1 AND NOT expression2
Remarks
• This operator is not available through the Studio interface, so you must manually type it into a query on a SQL or SQL Script panel.
• The expressions can be fixed values or comparisons.
Example (Single NOT)
SELECT orderdetails.*
FROM /shared/examples/ds_orders/orderdetails orderdetails
WHERE NOT (UnitPrice > 100.00)
Example (Two NOTs)
SELECT orderdetails.*
FROM /shared/examples/ds_orders/orderdetails orderdetails
WHERE NOT (UnitPrice > 100.00) AND NOT (Quantity < 2)