Select all where column is null

The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Asked 9 years, 10 months ago. Active 4 months ago. Viewed k times. Improve this question. Dexter Dexter 1 1 gold badge 2 2 silver badges 5 5 bronze badges. Add a comment. Active Oldest Votes.

Improve this answer. Zikato 4 4 silver badges 14 14 bronze badges. Aaron Bertrand Aaron Bertrand k 25 25 gold badges silver badges bronze badges.

You should list out all the columns as per JNK's comment. Community Bot 1. Martin Smith Martin Smith It's still ugly, but it's less labor intensive ugly. While this seems quite useful, I do feel an obligation to note that it's not what the OP was asking for - they wanted the contents of each row that included a NULL value, not just a check to see if any exist.

Fair enough. I think I was just reading it differently. I was focused on the " Rene Rene Rizier 57k 16 16 gold badges 88 88 silver badges bronze badges. Deepankar Deepankar Please don't just write code as an answer. Explain what it does and how it works. Evan Carroll Evan Carroll I'm thinking they just want to see the relevant camouflaged data amidst the sea of hundreds of columns of NULLs everywhere.

That will help them to ultimately build a query with specific fields. 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. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.

Linked 6. Related Hot Network Questions. Question feed. Rafael 3 1 1 bronze badge. TwinPenguins TwinPenguins 3, 3 3 gold badges 16 16 silver badges 47 47 bronze badges. A F A F 21 2 2 bronze badges. If we need to keep only the rows having at least one inspected column not null then use this: from pyspark.

Mathieu B31 3 2 2 bronze badges. 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. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses.

Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.