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

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
13577 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / sivanagaraju

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

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the different sql commands?

1065

What is pl sql block structure?

1034

tell us something about heap tables. : Sql dba

1094

What is a join query?

952

What is the starting oracle error number?

1051

what is 'mysqlcheck'? : Sql dba

1011

Can we perform dml on view?

1040

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

965

Explain the methods used to protect source code of pl/sql.

1015

Are null values same as that of zero or a blank space?

1022

what is 'trigger' in sql? : Sql dba

1082

What are local and global Indexes and where they are useful.

1437

Can we join tables without foreign key?

957

Define overloaded procedure?

1075

What is sql clause?

1044