SELECT C1.COL1,C2.COL2,C3.COL3 FROM (SELECT COL1 FROM COLL WHERE COL1 <

wirte a query to remove null? following table are

col1 col2 col3
dinesh null null
null suresh null
null null prakesh
i want the output like

col1 col2 col3
dinesh suresh prkaesh

Question Posted / sivanagaraju

6 Answers
13515 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / sivanagaraju

SELECT C1.COL1,C2.COL2,C3.COL3
FROM (SELECT COL1 FROM COLL WHERE COL1 <>'NULL') C1,
(SELECT COL2 FROM COLL WHERE COL2 <>'NULL') C2,
(SELECT COL3 FROM COLL WHERE COL3<>'NULL') C3
WHERE C1.COL1 <>'NULL' AND C2.COL2<>'NULL';

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is embedded sql in db2?

994

How do I run a pl sql procedure in sql developer?

952

What is the difference between joins?

1021

how to get help information from the server? : Sql dba

915

Explain what is sql*plus?

1120

write an sql query to find names of employee start with 'a'? : Sql dba

1012

What is sql and also describe types of sql statements?

1037

What is difference between inner join and cross join?

952

How to revise and re-run the last sql command?

1145

What is a table partition?

1105

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1026

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1019

What is sqlite used for?

980

what is a foreign key ? : Sql dba

1064

Why do we use procedures in pl sql?

1008