Answer / soujanya

Nesting of queries, one within another, is termed as a Sub-
Query.

A sub query is executed once for the parent statement
whereas the correlated sub query is executed once for each
row of the parent query.
Example
Select deptno, ename, sal from emp a
where sal = (select max(sal) from emp
where deptno = a.deptno)
order by deptno

Answer / ram

partially parent query will excute(this will give some out
put).these output will use in sub query,after parent query
fully excuted.sub query depend on parent query.

Answer / raj

A simple answer with a query will gives you answer for
subquery & co-related sub query.

Select dept, sal from table1
where sal = (select max(sal) from table1
where dept = table1.dept.

Tell me about linked universe ?

5 Answers   Tech Mahindra,

---

There are 2 types of strategies are there? 1. Built-in Strategy 2. External Strategy can you please explain them in complete that what are these? Thanks in Advance

1 Answers  

---

IS THERE ANY OTHER TOOL AVAILABLE TO DESIGN/CREAT UNIVERSE? EXCEPT UNIVERSE DESIGNER

3 Answers   IBM, TCS,

---

5.what is slowly changing dimension ?

2 Answers   IBM,

---

How toconnect one to one report?

4 Answers   iFlex,

---

---

What are the data types present in bo? What happens if we implement view in the designer and report?

0 Answers  

---

what is master-detail report

3 Answers   Patni, TCS,

---

We can have two separate installations of BOE XI 3.1 on a single server?

2 Answers  

---

How do scheduling the report in BO XIR2? can you say what are they steps?

5 Answers  

---

what are the documentations u r created?

2 Answers   Wipro,

---

I have 4 tables having many to many relationships between the tables? How i can get correct results in the report?

2 Answers  

---

Explain how many universes can be created in a project?

0 Answers  

---