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
13605 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 the difference between delete and truncate statement in sql?

1071

How do I run a script in sql developer?

950

how can we know the number of days between two given dates using mysql? : Sql dba

1048

what is 'mysqlcheck'? : Sql dba

1016

What is the largest value that can be stored in a byte data field?

1012

What are the advantages of indexing?

986

Can we use update in sql function?

1064

What is a procedure in pl sql?

1212

Explain the structure of pl/sql in brief.

1095

Is sql microsoft?

1058

what is the use of double ampersand (&&) in sql queries?

1176

how to select unique records from a table? : Sql dba

1113

What are the two types of exceptions.

1171

what is schema? : Sql dba

1050

How can you know that statistics should be updated?

1079