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
13505 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

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1003

What kind of join is join?

944

How many types of triggers exist in pl/sql?

1047

How do you explain an index?

1264

what is a composite key ? : Sql dba

1030

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1040

What are the two different parts of the pl/sql packages?

1066

what is auto increment? : Sql dba

990

Which is faster count (*) or count 1?

1008

Can we join tables without foreign key?

943

What is cascade in sql?

943

What is recursive stored procedure?

1081

how do you control the max size of a heap table? : Sql dba

958

i have some prob lem to tell me about my self in interview first round ...

2149

What is a field in a database?

1042