what is subqueary and what is temporary tables?
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 |
What is a conditional attribute in microstrategy?
What are intelligent cubes?
What do you mean by mstr? What are the different types of mstr objects?
Is microstrategy desktop available in other languages?
What is the difference between absolute filtering and standard filtering?
How would you increase the logical size of a table in microstrategy?
How do users receive only information that they want?
Can you explain surrogate key?
What information is shared by the application across microstrategy web nodes?
If your client wanted to customize the null value, how would you do that?
Can intelligence server integrate with my existing data structure?
What are the benefits of using microstrategy intelligence server?