{"id":159,"date":"2024-08-21T05:46:22","date_gmt":"2024-08-21T05:46:22","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=159"},"modified":"2025-05-09T08:53:55","modified_gmt":"2025-05-09T08:53:55","slug":"sql-not","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/sql-not\/","title":{"rendered":"SQL Not"},"content":{"rendered":"\n

The SQL Not clause is sused to filter records by excluding those that meet a certain condition. It is essentially the opposite of the WHERE clause condition.<\/p>\n\n\n\n


<\/p>\n\n\n\n

SQL Not Syntax<\/h2>\n\n\n\n
SELECT column1, column2, ...\nFROM table_name\nWHERE NOT condition;<\/pre><\/div>\n\n\n\n

<\/p>\n\n\n\n
SQL Not Example<\/h2>\n\n\n\n
This query selects the first_name, last_name, and gender columns from the patients table.<\/p>\n\n\n\n
SELECT first_name, last_name, gender\nFROM Patients\nWHERE NOT gender = 'F';<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n
Try It Out!<\/a><\/div>\n<\/div>\n\n\n\n

<\/p>\n\n\n\n
SQL NOT Using NOT with Multiple Conditions Example<\/h3>\n\n\n\n
This query selects the first_name, last_name, contact_number and dob columns from the Patients table, applying a condition using NOT operator.<\/p>\n\n\n\n
SELECT first_name, last_name, contact_number, dob\nFROM Patients\nWHERE NOT (contact_number IS NOT NULL OR dob > '1985-01-01');<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n
SQL NOT Combining NOT with Other Clauses Example<\/h3>\n\n\n\n
This query retrieves all the patients whose first_name does not start with the  letter “A” and whose dob (date of birth) is not exactly ‘1990-01-01’.<\/p>\n\n\n\n
SELECT first_name, last_name, dob\nFROM Patients\nWHERE NOT first_name LIKE 'A%' AND NOT dob = '1990-01-01';<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n
SQL Not Visual Diagram<\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

<\/p>\n\n\n\n
SQL Not Labs<\/h3>\n\n\n\n