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
15240 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 will you get by the cursor attribute sql%notfound?

1057

What is an alias command?

1063

Who developed sql?

1039

what is the difference between delete and truncate commands? : Sql dba

1067

What is over () in sql?

953

What is the difference between syntax error and runtime error?

1138

What are triggers and its types?

1055

How can you view the errors encountered in a trigger?

960

What is the source code of a program?

1069

What is cursor explain with example?

982

what is a relationship and what are they? : Sql dba

1097

What is the primary use of normalization?

1000

What does 0 mean in sql?

963

Why is partition used in sql?

1122

Is trigger a stored procedure?

932