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
13793 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 Histogram?

1611

What is normalization? How many normalization forms are there?

1139

How is a PL/SQL code compiled?

1283

Is pl sql different from sql?

1041

How do you write an index?

1007

What is meant by <> in sql?

1026

what are rollup and cube in t-sql? : Transact sql

1149

How does one use sql*loader to load images, sound clips and documents? : aql loader

1233

How to add, remove, modify users using sql?

1089

What is trigger with example?

1168

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

1054

how to get a list of columns in an existing table? : Sql dba

1008

difference between anonymous blocks and sub-programs.

1188

What are conditional predicates?

1121

Could you please provide oca (oracle 10g) dumps for my certification ?

5239