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
13506 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 is a table?

996

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

937

How do I order by ascending in sql?

989

What jobs use sql?

964

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

975

What is difference between ms sql and mysql?

943

What is an alias command?

1036

What is error ora-12154: tns:could not resolve the connect identifier specified?

1052

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

952

what is the stuff function and how does it differ from the replace function? : Sql dba

1024

What is trigger explain it?

990

What is update query?

958

what is denormalization. : Sql dba

1086

Does sql backup shrink transaction log?

953

what are the join types in tsql? : Transact sql

1044