Skip to content
Advertisement

Tag: null

How to select columns from a table which have non null values?

I have a table containing hundreds of columns many of which are null, and I would like have my select statement so that only those columns containing a value are returned. It would help me analyze data better. Something like: Select (non null columns) from tablename; I want to select all columns which have at least one non-null value. Can

SQL Inner Join On Null Values

I have a Join Isnull in a Join like this makes it slow. It’s like having a conditional Join. Is there any work around to something like this? I have a lot of records where QID is Null Anyone have a work around that doesn’t entail modifying the data Answer You have two options or easier

Advertisement