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

What is query execution plan in sql?

0 Answers  

How can we overcome recursive triggers in SQL?

1 Answers   iFlex,

what is explain plan?, given an example...

3 Answers   Polaris,

What are the qualities of 2nf?

0 Answers  

What is the difference between mdf and ndf files?

0 Answers  

Write a query to find second highest salary of an employee.

27 Answers  

What can be a size of a pl/sql block? Is there any limit?

2 Answers  

Why is the cursor important?

0 Answers  

Are views faster than queries?

0 Answers  

what is difference between stored procedures and application procedures,stored function and application function?

1 Answers  

What is the difference between a procedure and a function?

0 Answers  

Explain the difference between 'between' & 'and' operators in sql

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories