SQL Server: COALESCE Instead of Not Null

I had a table of 10 K records and 10 columns. Most of the records had NULL values in one or two columns. They may be any column as in below screenshot. I needed to filter all records for which at least one value is filled.



So initially I thought of writing query as below.
SELECT * FROM ItemDetails WHERE
[Desc] IS NOT NULL OR Color IS NOT NULL OR
Size IS NOT NULL OR Shape IS NOT NULL OR plasticfree IS NOT NULL
I found an query which is more easier using COALESCE function which results same as above query.
SELECT * FROM ItemDetails WHERE COALESCE([Desc],Color,Size,Shape,plasticfree) IS NOT NULL

No comments:

Post a Comment