Sql select all fields not null

I agree with Uri Dimant, as the column list can not be dynamically changed in the query result. Moreover, one row may have a null value for a given column but another row might again have a non null value. Alternately, you can have a fixed column list with aliasing and use a Coalesce function for the non-null value. HTH, Cheers!! Ashish Please mark it as Answered if it answered your question or mark it as Helpful if it helped you solve your problem.

Sign in. United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. Anax gave me an idea so I went looking. At the bottom I added a way to make it so you have a select statement so you don't have to iterate through however many columns.

Useful if you have a dynamic table where you can't update your select statement — Sam. Anax Anax 8, 5 5 gold badges 30 30 silver badges 66 66 bronze badges. Brane 2, 2 2 gold badges 35 35 silver badges 52 52 bronze badges. Community Bot 1 1 1 silver badge. Martin Smith Martin Smith k 81 81 gold badges silver badges bronze badges. If you are having other datatypes it throws error. Nikita Popov 8 8 silver badges 17 17 bronze badges.

Dipu Dipu 21 2 2 bronze badges. David Swindells David Swindells 1 1 gold badge 12 12 silver badges 28 28 bronze badges. Sam Sam 1, 12 12 silver badges 16 16 bronze badges. Evan Carroll Evan Carroll Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.

Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. You are commenting using your Google account.

You are commenting using your Twitter account. You are commenting using your Facebook account. Notify me of new comments via email. Notify me of new posts via email. This site uses Akismet to reduce spam. Learn how your comment data is processed. Skip to content Sometimes there happens to be a situation where we have a table containing more than 30 or 40 columns and most of the columns contain no value null Assuming that null columns are not defined as a sparse column.