Interested to Buy Any Domain ? << Click Here >> for more details...
what is subqueary and what is temporary tables?
- 3 Answers
- 7410 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 |
Write the components microstrategy metadata?
You have got the requirement from a client. Explain the technical approach you will take now.
Explain heterogeneous mapping?
What are different types of metrics in microstrategy?
What do you mean by mstr?
What leads to a cross-join or how does a cross-join occur?
Is microstrategy desktop available in other languages?
What do you mean by staging area?
How can i optimize a report in microstrategy environment?
Explain microstrategy logical primary keys?
what are the different types of tests done on a microstrategy report?
What do you mean by static prompt report?
Teradata 
