Sign Up Login


  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

Explain about various levels of constraint.

0 Answers  

State few characteristics of pl/sql?

0 Answers  

What is a temporal table?

0 Answers  

Which table is left in left join?

0 Answers  

what is SCALAR Queries?

2 Answers   ITC Infotech,




we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?

3 Answers   TCS,

What are code pages ?

1 Answers   BirlaSoft,

what is innodb? : Sql dba

0 Answers  

There is a sequence with min value 100. I want to alter this sequence to min value as 101. If the table has already data in the sequence column as 100,101,102... Is it possible to do so ?

4 Answers   IBM,

query to retrive the employees whose sal is greater than avg sal

10 Answers   TCS,

What is a nested table in word?

0 Answers  

What is using in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories