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
13788 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 join? : Sql dba

1083

What is a schema sql?

1224

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1081

What is the difference between an inner join and an outer join?

1079

What is the best free sql database?

1101

What is rollback?

1184

How do I save a sql query?

1066

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1080

how to convert numeric values to character strings? : Sql dba

1154

how to get a list of all tables in a database? : Sql dba

1028

What is rank function in sql?

1069

What is a sql statement?

1016

Can two tables have same primary key?

1022

explain advantages of innodb over myisam. : Sql dba

1175

How can we implement rollback or commit statement in a trigger?

1083