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

Why commit is not used in triggers?

1091

What is informix sql?

1032

What are the parameter modes supported by pl/sql?

1155

What is the difference between joins?

1094

How do I view tables in sql developer?

1009

what are myisam tables? : Sql dba

1079

What is a sql select statement?

1082

What is dynamic sql in pl sql?

1090

Can a primary key be a foreign key?

1081

How do I run sql?

1256

How do you run a query?

1052

What company owns postgresql?

1094

Which is faster truncate or drop?

1104

What is the non-clustered index in sql?

1108

Which type of cursor is used to execute the dml statement?

997