Need to edge out the competition for your dream job? Train for certifications today.
"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.
select * from YourTableName WHERE NOT YourColumn IS NULL
Open in new window
I want MSSQL to exclude all the NULL result in columns from the table.
Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.
How do i exclude all the columns that is null?
WHERE nullable_col1 IS NOT NULL and nullable_col2 IS NOT NULL
1. Add only NOT NULL columns in your SELECT clause.
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment