The only option I feel is SELECT * FROM TABLE WHERE COL

how to eliminate null values in a column i.e
table vlaues
1 2 3
NULL 3 4
1 5 NULL
i want output like this
1 2 3
3 4
1 5
i dnt want to use nvl is null and i dnt want replace the
NULL value with any value i.e nvl(col,o);

Question Posted / dipti

11 Answers
14806 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / dipti

The only option I feel is

SELECT * FROM TABLE
WHERE COL_NAME IS NOT NULL

will return the non null values which I think is asked for
this question.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the syntax and use of the coalesce function?

1103

Why is partition used in sql?

1049

how many sql ddl commands are supported by 'mysql'? : Sql dba

955

What mean sql?

951

define sql update statement ? : Sql dba

1048

what is data integrity? : Sql dba

985

what is a tablespace? : Sql dba

1004

Is sql sequential or random?

981

Which operator is used in query for pattern matching?

1032

Inline the values in PL/SQL, what does it mean.?

1156

Why do we use joins in sql?

908

How to use transactions efficiently : transact sql

991

What is program debugging?

1129

how to decrement dates by 1 in mysql? : Sql dba

967

What is pl/sql table? Why it is used?

989