Interested to Buy Any Domain ? << Click Here >> for more details...
what is subqueary and what is temporary tables?
- 3 Answers
- 7343 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
Explain microstrategy logical primary keys?
What do you mean by mstr?
How is security handled?
Explain attribute?
What are the different formatting types?
What are the various ways of incorporating security in microstrategy?
At which levels you can set the vldb properties? Which level has the highest pecedence?
Explain the Roles in mstr?
Write the different types of matrices in microstrategy?
Does microstrategy intelligence server support scheduling?
Your i-sever crashed. What will you do?
How does microstrategy object manager determine if two objects in different projects are the same?
Can you explain surrogate key?
differentiate between two-tier, three-tier and four-tier connections.
Difference between project merge and object manager in microstrategy?
