Interested to Buy Any Domain ? << Click Here >> for more details...
what is subqueary and what is temporary tables?
- 3 Answers
- 7506 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 information is shared by the application across microstrategy web nodes?
Your account is locked and your administrator has forgotten the password. What would you do?
what is a security filter?
Name the various types of filters?
Can I deploy a single bi application in multiple languages?
What do you mean by derived metrics?
What happens if the owner of an object does not exist in the destination project?
Does microstrategy intelligence server run on windows®, unix®, or linux®?
What are different types of metrics in microstrategy?
What is percent-to-total shortcut metric in microstrategy?
What formatting can be applied to the information that is sent out by microstrategy narrowcast server?
Can a record be inserted and updated in database using microstartegy?
Can reports be executed in off-peak periods?
Explain attribute role?
What are vldb properties in microstrategy?
