what is subqueary and what is temporary tables?
- 3 Answers
- 6025 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
You have got the requirement from a client. Explain the technical approach you will take now.
How do you optimize reports in microstartegy?
What is the difference between absolute filtering and standard filtering?
How to use consolidations in microstrategy report?
If your client wanted to customize the null value, how would you do that?
Explain fact structure?
Explain true primary keys?
How can the user determine the object id of an object?
Explain compound key?
Difference between project merge and object manager?
Does microstrategy web support clustering via cisco local router or any other third-party clustering software?
What is static prompt in microstrategy?
Your colleague installed microstrategy on solaris or unix without root access. Will he be able to start/ restart this server?
Name the various types of filters?
What do you mean by bulk export report?
