{"id":505,"date":"2024-08-30T01:58:55","date_gmt":"2024-08-30T01:58:55","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=505"},"modified":"2025-06-02T12:38:10","modified_gmt":"2025-06-02T12:38:10","slug":"is-not-null","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/is-not-null\/","title":{"rendered":"IS NOT NULL"},"content":{"rendered":"\n

SQL IS NOT NULL Keyword<\/h2>\n\n\n\n

The IS NOT NULL condition checks for columns that have actual values\u2014not empty or missing. This is helpful when filtering only complete records or valid references.<\/p>\n\n\n\n

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

SQL IS NOT NULL Syntax<\/h2>\n\n\n\n
SELECT column1, column2, ...\nFROM table_name\nWHERE column_name IS NOT NULL;<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL IS NOT NULL Appointments with Doctor Example<\/h2>\n\n\n\n
This query returns all appointments that are linked to a doctor:<\/p>\n\n\n\n
SELECT appointment_id, doctor_id, appointment_date\nFROM Appointments\nWHERE doctor_id IS NOT NULL;<\/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 IS NOT NULL with JOIN Example<\/h2>\n\n\n\n
This query returns doctor names and their assigned appointments (only if doctor_id is present):<\/p>\n\n\n\n
SELECT Doctors.first_name, Doctors.last_name, Appointments.appointment_date\nFROM Doctors\nJOIN Appointments ON Doctors.doctor_id = Appointments.doctor_id\nWHERE Appointments.doctor_id IS NOT NULL;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL IS NOT NULL Labs<\/h2>\n\n\n\n