write a query to remove null value follwing table? col1 col2 col3 dinesh n

write a query to remove null value follwing table?
col1 col2 col3
dinesh null null
null suresh null
null null prakesh

i want the output

col1 col2 col3
dinesh suresh prakesh

Question Posted / dinesh

4 Answers
8470 Views
Accenture, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null s..

Answer / srinivas kondeti

SELECT MAX(COL1),MAX(COL2),MAX(COL3) FROM TABLE_NAEM

Is This Answer Correct ?

11 Yes

1 No

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null s..

Answer / chandrasekar

Hi Srinivas how the sql query execute because the query
returns only max values.. so please clarify.

Is This Answer Correct ?

1 Yes

1 No

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null s..

Answer / sasibushan

This will work

SELECT Max(CASE WHEN col1 IS NOT NULL THEN col1 END) AS "col1",
Max(CASE WHEN col2 IS NOT NULL THEN col2 END) AS "col2",
Max(CASE WHEN col3 IS NOT NULL THEN col3 END) AS "col3"
FROM Table_name

Convert this logic to Informatica...

Sasi.

Is This Answer Correct ?

1 Yes

1 No

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null s..

Answer / rahul

In Informatica use aggrigator on group by Col1 Col2 Col3.

Is This Answer Correct ?

2 Yes

2 No

Post New Answer