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

Do we need to rebuild index after truncate?

1035

Why do we go for stored procedures?

1058

What is your daily office routine?

2272

How to know the last executed procedure?

1099

What is bulk collect in pl sql?

1089

How many types of sql are there?

986

Sql technical questions

1283

What are the types of optimization?

961

what are the differences between char and varchar? : Sql dba

1072

What are basic techniques of indexing?

1384

Is record in pl sql?

975

How many types of triggers are there in pl sql?

1067

What does sql stand for?

998

what is a trigger in mysql? Define different types of trigger. : Sql dba

1069

What is difference between procedure and trigger?

982