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

Explian rowid, rownum?

956

How do I start sql profiler?

940

What is a natural join?

991

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1044

Define union, minus, union all, intersect ?

949

How do I save a stored procedure?

946

What is sql procedures and functions?

954

How would you reference column values before and after you have inserted and deleted triggers?

1016

Are views faster than queries?

916

what is primary key? : Sql dba

952

explain commit and rollback in mysql : sql dba

937

What is not null in sql?

984

Is sql database free?

923

What is the meaning of disabling a trigger?

1110

what are the features and advantages of object-oriented programming? : Sql dba

951