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
13576 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

Can we join same table in sql?

1014

What is primary key sql?

1030

What is sql character function?

1070

What is an implicit commit?

1048

How many sql statements are used? Define them.

1035

What are the types of index in sql?

1063

How can you load multi line records? : aql loader

1071

Can we change the table name in sql?

937

Can we enter data in a table in design view?

965

How do you delete data from a table?

1023

What will you get by the cursor attribute sql%notfound?

1057

What is java sql drivermanager?

1081

How do I view a view in sql?

948

What is recursive join in sql?

1004

How many types of cursors supported in pl/sql?

1180