Answer / vamsi

Use Nested Derived Table

Answer / prabha

A correlated subquery is a SELECT statement nested inside
another T-SQL statement, which contains a reference to one
or more columns in the outer query. Therefore, the
correlated subquery can be said to be dependent on the
outer query. This is the main difference between a
correlated subquery and just a plain subquery. A plain
subquery is not dependent on the outer query, can be run
independently of the outer query, and will return a result
set. A correlated subquery, since it is dependent on the
outer query will return a syntax errors if it is run by
itself.

Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

0 Answers  

---

please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and self join with database tables.

2 Answers   Wipro,

---

How to get two dimension objects in a same block which are comming from two different contexts ?

1 Answers  

---

Hi All, I have found out this site very interesting and knowledge sharing site.I was wondering if you can tell me where I can get study materials for the BO XI 3.1 or suggest me the one that you have taken recently. Regards, Ace

1 Answers  

---

HOw do u migrate from old version to the new version?

1 Answers   AOL,

---

whats the diff between break and section

4 Answers   TCS,

---

Explain about derived tables?

2 Answers   Cap Gemini,

---

How to generate the report from excel sheet?

0 Answers  

---

Say, the query gets executed and we got the results. In case if we have a large number of rows, how can we know the exact no of rows returned?

6 Answers  

---

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

0 Answers  

---

WHAT IS THE DIFF BETWEEN BO6.5 AND BOXI

5 Answers   TCS,

---

what are the tables used in health care domain project and columns used in report?

0 Answers   IBM,

---