suppose we hav,table name: demo values ------ 1 2 3 NULL 3 4 1 5

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 / lavanya

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

Answer Posted / lavanya

suppose we hav,table name: demo
values
------
1
2
3
NULL
3
4
1
5
NULL

select values from demo where values!=NULL

Is This Answer Correct ?

0 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is the difference between union and union all? : Sql dba

1017

Name three sql operations that perform a sort.

1002

How is debugging done?

972

What is full join in sql?

988

Write the alter statement to enable all the triggers on the t.students table.

1123

What is the starting oracle error number? What is meant by forward declaration in functions?

989

Explain the uses of control file.

1048

What is difference between hql and native sql?

1166

How to start the command-line sql*plus?

1049

What are all the common sql functions?

1014

What are the three pl sql block types?

1006

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

1020

How does sql profiler work?

1016

what is a tablespace? : Sql dba

1049

How do sql triggers work?

1035