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

Can you selectively load only those records that you need? : aql loader

983

How to set up sql*plus output format in oracle?

973

What is the starting oracle error number? What is meant by forward declaration in functions?

937

Why is sql important?

1026

what is index? : Sql dba

942

what is self-join? : Sql dba

1054

What is an implicit commit?

990

What is orm in sql?

992

What information is needed to connect sql*plus an oracle server?

977

What is the difference between sql, mysql and sql server?

1013

Can there be 2 primary keys in a table?

951

What is nosql example?

968

Does sql view stored data?

897

Can you upgrade sql express to full sql?

994

What is the difference between sql and t sql?

963