where condition based on not null column

Accepted answer

The following example shows how COALESCE selects the data from the first column that has a nonnull value.

SELECT Name, Class, Color, ProductNumber,   COALESCE(Class, Color, ProductNumber) AS FirstNotNull

   FROM Production.Product;

+1

rama krishna10y ago

The questioner needs to find out not nullable value among all columns.by using null functions we can find null or not among two columns. Could you please go through the COALESCE function.

0

Bikesh Srivastava10y ago

In sql you only two way to check null value.

1.NullIff

2.Is null

0

ketan borsdiya10y ago

Hi Arvind,

use like below,

select *from table where Col1 is null

-1