Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

Does pl/sql support create command?

0 Answers  

Which is faster count (*) or count 1?

0 Answers  

How do I view a table in sql?

0 Answers  

how to use regular expression in pattern match conditions? : Sql dba

0 Answers  

Define a temp table?

0 Answers  

what are the authentication modes in sql server? How can it be changed? : Sql dba

0 Answers  

What types of commands can be executed in sql*plus?

0 Answers  

What is using in sql?

0 Answers  

What is normalization ?

9 Answers   BirlaSoft, CTS, HCL,

How do you modify a table in sql?

0 Answers  

How do you add a column to a table?

0 Answers  

What does an inner join do?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories