Forum Discussion

AkashGupta245's avatar
AkashGupta245
Copper Contributor
Jul 14, 2022

Null Question

Hello Guys, 

i am totally new and just started  SQL 1 weeks age i have come across a problem in SQL

suppose i am working on huge amount of data which is unclean and i want to find NULL & i know the syntax of null but suppose i have almost 50 columns and i want to find out in which row there is NULL is there any we can find NULL or Blank field in this vast data because it will take a lot of time if i just put null syntax and writing one by one column

 

please assist me. thank you

2 Replies

  • isaaclewis's avatar
    isaaclewis
    Copper Contributor
    Jul 18, 2022
    This SO answer has a pretty clever idea for this: https://stackoverflow.com/questions/14488859/find-all-rows-with-null-values-in-any-column