Interested to Buy Any Domain ? << Click Here >> for more details...
what is subqueary and what is temporary tables?
- 3 Answers
- 7405 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 |
Your i-sever crashed. What will you do?
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?
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 is a joint child?
According to you, what are the most important tables in a dw? Why?
Can microstrategy intelligence server scale easily and cost effectively based on my growing needs?
I am in chennai.I need Micro strategy ,Informatca & BO cd (not orginal)Please where get that.I really this badly. Regards, Raji
How can you make the sql query to be based on a specific table of your choice?
You have got the requirement from a client. Explain the technical approach you will take now.
Explain batch?
Is it possible to see the data in dataset?
Can the administrator easily maintain and manage microstrategy intelligence server?
Teradata 
