Interested to Buy Any Domain ? << Click Here >> for more details...
what is subqueary and what is temporary tables?
- 3 Answers
- 7342 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 |
What do you mean by xml cache?
Explain true primary keys?
While establishing relationship between attributes how do you decide which attribute qualifies as child and which one as parent?
What is the conflict resolution window?
Is that possible to Insert and Update a record in the Database through Microstrategy..?
What is static prompt in microstrategy?
Explain attribute role?
What is a conditional attribute in microstrategy?
What leads to a cross-join or how does a cross-join occur?
Is it possible to Delete duplicate rows at row level?
Your account is locked and your administrator has forgotten the password. What would you do?
How is the number of passes in a sql query significant in performance evaluation?
Teradata 
