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
15648 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 does rownum mean in sql?

1091

What is number function in sql?

1018

When is the explicit cursor used ?

1093

How does cross join work in sql?

1079

How will you distinguish a global variable with a local variable in pl/sql?

1203

What is the difference between pl and sql?

1153

What is difference between inner join and self join?

1139

How do I audit the sql sent to the server?

1061

What is schema in sql?

1006

How do I view output in sql developer?

1126

Is sql database free?

1029

Does a user_objects view have an entry for a trigger?

1051

what is an extent ? : Sql dba

1163

What is the maximum number of columns in sql table?

1231

What is the difference between unique and primary key constraints?

1122