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

Explain the commit statement.

0 Answers  

How do I find duplicates in two columns?

0 Answers  

what are enums used for in mysql? : Sql dba

0 Answers  

Describe the Index, Types of index, At what situation we have used? Which one s better than others?

1 Answers   IBM, TCS,

Is primary key clustered or nonclustered?

0 Answers  

What is right join in sql?

0 Answers  

i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk

1 Answers   Aspire,

How can we schedule the procedure to run automatically ?

3 Answers  

what is top in tsql? : Transact sql

0 Answers  

What is the relation b/w view and trigger

3 Answers   Accenture, TCS,

What is a composite primary key?

0 Answers  

How does left join work in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories