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

What is a stored procedure in sql with example?

1124

What is multiple columns?

1064

What is procedure explain with example?

955

What is normalization in sql?

1009

How do I remove sql developer from windows 10?

1102

how to create a test table in your mysql server? : Sql dba

1004

How can we optimize a sql query?

1045

What is the difference between rollback and rollback to statements?

1060

Explain isolation levels. : Transact sql

1068

How do you rank data in sql?

999

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3567

How to find 3rd highest salary of an employee from the employee table in sql?

1079

What is anonymous block in sql?

1118

How do I start sql from command line?

1019

What is the difference between the conventional and direct path loads? : aql loader

1392