Interested to Buy Any Domain ? << Click Here >> for more details...
what is subqueary and what is temporary tables?
- 3 Answers
- 7199 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 holap and rolap?
hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com
Difference between project merge and object manager in microstrategy?
how can we direct the sql generated to use a specifc table?
Name different type of objects in microstrategy?
Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?
What does microstrategy intelligence server allow users to do?
What olap capabilities do I have within a microstrategy report services document?
How can we use consolidations in microstrategy report
What is the difference between microstrategy and cognos reporting tool?
Can microstrategy desktop access operational data systems?
Is it possible to limit the number of reports run by a users at a time? How? What will happen if this limit is exceeded?
Teradata 
