SELECT DISTINCT((SELECT COL1 FROM COLL WHERE COL1<>'NULL'))

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
13798 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / sivanagaraju

SELECT DISTINCT((SELECT COL1 FROM COLL WHERE COL1<>'NULL')),(SELECT COL2 FROM COLL WHERE COL2<>'NULL'),(SELECT COL3 FROM COLL WHERE COL3<>'NULL')
FROM COLL

Is This Answer Correct ?

4 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Will truncate release space?

990

What is auto increment feature in sql?

1174

What are string functions in sql?

1305

Mention what pl/sql package consists of?

1044

how would you get the current date in mysql? : Sql dba

1017

How do you update a value in sql?

1103

What is database white box testing and black box testing?

1157

What are all ddl commands?

1129

What is crud sql?

1029

How do you rank data in sql?

1069

what is clause? : Sql dba

1118

Is pl sql better than sql?

1088

how can we find the number of rows in a table using mysql? : Sql dba

1129

How do you declare a variable in pl sql?

1071

What is lexical units in pl sql?

1207