Interested to Buy Any Domain ? << Click Here >> for more details...
what is subqueary and what is temporary tables?
- 3 Answers
- 7414 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 do you mean by trimming sql in microstrategy?
What are the different types of metrics available in microstrategy?
What are the benefits of using microstrategy intelligence server?
In Microstrategy, how can you direct the sql generated to use a specifc table?
What is the effect of dls on microstrategy?
Does microstrategy intelligence server support scheduling?
How can i optimize a report in microstrategy environment?
Explain true primary keys?
What is difference between Union and Union All ?
In document how to create metrics?Explain
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
explain html document?
Teradata 
