To retrieve all records whose a particular column value is NULL, we can use
“is” keyword followed by null.
Assume that we have 4 records in the database table and we want to return only that record from the database whose
Execute following query in the query window.
SELECT * FROM PersonalDetails
WHERE LastName is null
This would return only one record from the PersonalDetails database table.
Views: 2655 | Post Order: 49