SQL: Select all columns from Table whose value is NOT NULL

Hi 4ashwani,

Check this example. Now please take its reference and correct your code.

Input

DECLARE @Test AS TABLE(pid INT,metal VARCHAR(20),weight1 INT,weight2 INT)

INSERT INTO @Test VALUES(1,'metal 1',10,20)
INSERT INTO @Test VALUES(2,'metal 2',NULL,30)
INSERT INTO @Test VALUES(3,'metal 3',40,NULL)
INSERT INTO @Test VALUES(4,'metal 4',50,60)
INSERT INTO @Test VALUES(5,'metal 5',NULL,NULL)
INSERT INTO @Test VALUES(6,NULL,70,80)

Query

SELECT pid
	   ,metal
	   ,weight1
	   ,weight2 
FROM @Test
WHERE metal IS NOT NULL
AND weight1 IS NOT NULL
AND weight2 IS NOT NULL

Output