SQL Server > Query

Records having null value in SQL Server

How to get records having null value in a column of SQL Server database table?


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 LastName is null.

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: 10644 | Post Order: 49



Write for us






Hosting Recommendations