what is subqueary and what is temporary tables?
- 3 Answers
- 6250 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 |
Explain the difference between rolap and molap?
What do you mean by bulk export report?
Is there a difference between view filter and report filter?
How is security handled?
# how to increase logical sige of a table in microstrategy
How conflicts occur and what are the ways to resolve them?
Can I deploy a single bi application in multiple languages?
Does microstrategy intelligence server run on windows®, unix®, or linux®?
What is difference between Union and Union All ?
Name the types of transformation?
At which levels you can set the vldb properties? Which level has the highest pecedence?
what do you mean by security filter?
Teradata 
