what is subqueary and what is temporary tables?
- 3 Answers
- 6254 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
What formatting can be applied to the information that is sent out by microstrategy narrowcast server?
How do users receive only information that they want?
What is the difference between microstrategy and cognos reporting tool?
Can you explain surrogate key?
Explain the difference between holap and molap?
What is a dw? Why do we need it?
You are required to update a table in warehouse. Can you do it with the help of microstrategy?if yes, how?
How can users design dashboards quickly and without programming experience or training?
Explain 4gt switch. Does it have any drawback?
Explain factless facts?
What is a compound attribute in microstrategy?
How would you get two images on microstrategy login page?
What security is provided with microstrategy desktop?
Is it possible to limit the number of reports run by a users at a time? How? What will happen if this limit is exceeded?
Compare microstrategy and tableau.
