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

is mysql query is case sensitive? : Sql dba

1101

What are the different types of functions in sql?

1055

What is cursor in pl sql with examples?

1033

Can a select statement fire a trigger?

1158

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1036

Mention what does the hierarchical profiler does?

1090

how to write date and time literals? : Sql dba

959

Show how functions and procedures are called in a pl/sql block.

1127

Is ms sql is free?

1020

How does postgresql compare to mysql?

1034

What is an alias command?

1068

what is the difference between char and varchar data types? : Sql dba

1112

How many tables can you join in sql?

957

Explain the types of joins in sql?

1035

What are the sql versions?

944