Skip to content
Advertisement

Tag: null

sql query to exclude not null columns

I have below table and records Now i do not want to display the rows having null values in the columns except primary key column. I used below query to arrive the above result. But my orginal table having 72 columns how can i check all the columns for getting above result. / Answer You could check the length of

Query null values

I have the column deletedTime in my instances table. Now I want to check in ColdFusion if the value is null. There is only one record to be printed out with the query. IsNull(test) is returning the …