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
13324 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 need of merge statement?

987

What is plpgsql language?

977

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7134

What is a join query?

905

Mention what is the use of function "module procedure" in pl/sql?

1005

Why do we use sql constraints?

1122

What are the different type of joins in sql?

905

what is the difference between where clause and having clause? : Sql dba

947

What is relationship? How many types of relationship are there?

1070

What is nosql example?

968

What are the two types of periodical indexes?

886

Why are aggregate functions called so?

896

what is the command line end user interface - mysql? : Sql dba

925

What is the usage of nvl function?

981

how do you know the version of your mysql server? : Sql dba

935