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


what is subqueary and what is temporary tables?

Answers were Sorted based on User's Feedback



what is subqueary and what is temporary tables?..

Answer / praveen

A Subquery or Inner query or Nested query is a query within
another SQL query and embedded within the WHERE clause.

A subquery is used to return data that will be used in the
main query as a condition to further restrict the data to
be retrieved.
Temparory tables are used in creation of storing data for a
while and this table is used in another sql .
That means the result of temp table will be used in another
sql up on which the resultant data is to be displayed.

Is This Answer Correct ?    5 Yes 0 No

what is subqueary and what is temporary tables?..

Answer / sunny

A query with another query is called sub query and temporary tables are used in creation of storing data for a while and tis tabel is used in another sql.

Is This Answer Correct ?    0 Yes 0 No

what is subqueary and what is temporary tables?..

Answer / guest

a query within another query is called Sub query

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Micro Strategy Interview Questions

How does microstrategy object manager determine if two projects are related?

0 Answers  


Can microstrategy intelligence server scale easily and cost effectively based on my growing needs?

0 Answers  


what specific features and functionality do you get with olap services?

0 Answers  


Explain the difference between rolap and molap?

0 Answers  


At which levels you can set the vldb properties? Which level has the highest pecedence?

0 Answers  


What are prompted filters? Have you ever used them? Where?

0 Answers  


What do you mean by derived metrics?

0 Answers  


What is pass through metrics in microstrategy?

0 Answers  


What is a dw? Why do we need it?

0 Answers  


why consolidation and custom group not used in ic cubes. and then i will over come by derived element.. what my question is ...even (consolidation and custom group) also derived element,why we are not used. Can any body give the assistant for this issues... Regards, sekhar

1 Answers   Cognizant,


Explain snowflake schema?

0 Answers  


What are the different types of metrics available in microstrategy?

0 Answers  


Categories