1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 / ramkrish.143

Answers were Sorted based on User's Feedback



how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL ..

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

More SQL PLSQL Interview Questions

How can I see all tables in sql?

0 Answers  

Why do we use partitions in sql?

0 Answers  

When do we use triggers?

0 Answers  

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

What is mutating sql table?

0 Answers  




What is the difference between truncate and drop statements?

0 Answers  

how to do backup entire database? : Transact sql

0 Answers  

how to drop an existing view in mysql? : Sql dba

0 Answers  

How to fetch common records from two tables?

1 Answers  

what is innodb? : Sql dba

0 Answers  

What does seeding a database mean?

0 Answers  

wt is the diff b/w greast and max ,least and min? wt is the diff b/w case and decod?

4 Answers   Oracle, TCS, Tecnics,

For more SQL PLSQL Interview Questions Click Here
Categories