All Forums Database
Mathuram 21 posts Joined 09/12
01 Dec 2012
How to find the records having NULL values

My table is having 250 columns, i need to retrieve the records having NULL values, few of the columns
having NULL Constraint, so i left those columns in my query.
 
SEL * FROM TableName WHERE Col1 is NULL or Col2 is NULL or Col3 is NULL... or Col250 is NULL
 
Can anyone help me to find the records having NULL values?

 

Qaisar Kiani 337 posts Joined 11/05
02 Dec 2012

In my point of view I think thats the only way of finding the records with null value in any of the column i.e. ignoring the columns with not null constraint and checking for the NULL values in the rest of the columns...

You must sign in to leave a comment.