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

why we are using derived tables ?how it will help?

Answer Posted / mayur

hi,

see i would like to answer it through on example:

consider the case where u retrive the data from the table xyz
by writing the "SELECT STATEMENT" & get the output ( say 5 rows) now their is the condition ....where u need this output(5 rows) for report/query..etc..

now, in such condition you can create an object of the above statement i.e "Select Statement" and store it in Derived table
& hence next time u will not require to write sql again...

& even a complex sql is effectively implemented...


finally this will enhance ur performance & a effective development logics ....

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain is there any default username & pwd for bo designer & supervisor?

959


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

2244


What is Indexing? how did u implement indexing?

2381


Explain what is the difference between slice and dice and cross tab report?

1027


What is the difference between condition & filter?

1406


Explain about a task that really tested your analytical abilities?

1201


What is object stores?

944


What are all difference between business objects 6.5 and xi r2?

983


Explain what three things do you consider to be the most important factors for a manager?

958


can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1342


1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

6791


Give some information on report bursting?

941


how get the grand total in master-detail report?

2184


What are the data types present in bo? What happens if we implement view in the designer and report?

984


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2059