what is subqueary and what is temporary tables?
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
How long does it take to get microstrategy desktop up and running?
what are the different types of fact structures?
Is it possible to apply themes to microstrategy web? How?
Name the types of transformation?
What are report filters and view filters?
Explain fact?
Is it possible to use microstrategy object manager while other users are making changes in microstrategy agent?
Can intelligence server integrate with my existing data structure?
Can we access multiple operational databases from within a single microstrategy project?
Explain transformations?
How does microstrategy object manager determine if two projects are related?
Can a record be inserted and updated in database using microstartegy?
What are configuration objects?
While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?
Explain md doctor?