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

Why select is used in sql?

1001

How do I view output in sql developer?

1067

Explain the uses of control file.

1026

Does a join table need a primary key?

941

what are sequences

1722

Can a commit statement be executed as part of a trigger?

1035

How do we accept inputs from user during runtime?

1043

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

959

What are different types of queries in sql?

1103

what is 'trigger' in sql? : Sql dba

1067

What are the two types of exceptions in pl/sql?

1027

What is fmtonly in sql?

1061

Compare sql & pl/sql

1104

What are the steps for performance tuning.

1317

How do you explain an index?

1267