You can use the NOT
operator in the WHERE
clause of SELECT
statement. You use it when you want to select a condition that is not true.
Here is a code example that selects all persons that are not male:
SELECT Id, Name, DateOfBirth, Gender
FROM Person
WHERE NOT Gender = "M"