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...

write a query to remove null value follwing table?
col1 col2 col3
dinesh null null
null suresh null
null null prakesh

i want the output

col1 col2 col3
dinesh suresh prakesh

Answer Posted / chandrasekar

Hi Srinivas how the sql query execute because the query
returns only max values.. so please clarify.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are mapplets?

1262


What can we do to improve the performance of informatica aggregator transformation?

1089


What does command task mean?

1134


How to use pmcmd utility command?

1022


Define pmcmd command?

1033


What is the commit type if you have a transaction control transformation in the mapping?

1028


What is the surrogate key?

1249


What is workflow? What are the components of the workflow manager?

1125


Briefly describe lookup transformation?

1040


What are the components of the workflow manager?

1124


what is diff b/t sorter t/r and agg have the option sorter property...

2169


Is there any target staging area in informatica not staging area

2572


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1190


Differentiate between sessions and batches?

1011


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2331