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

Can we create a trigger on view?

0 Answers  

Tell me what a package consists of.

3 Answers  

What does “select count(*) from tab” result?

15 Answers   IBM, Student, Wipro,

Can we join more than 2 tables in sql?

0 Answers  

Can we have two clustered index on a table?

0 Answers  

What is the fastest way of accessing a row in a table?

5 Answers   TCS,

What is vector point function?

0 Answers  

Can a foreign key be a duplicate?

0 Answers  

how to fetch common records from two tables? : Sql dba

0 Answers  

How does join work in sql?

0 Answers  

how can i create a user defined datatype

3 Answers  

what is data integrity? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories