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.

can any one say me exactly when and where alias and context are used in resolving a loop. If possible try to give me a scenario also.

3 Answers  

---

what is the difference between Ranking and sort-out in bo?

2 Answers   iNautix, TCS,

---

Can we do the slice and dice in webintellegence?

5 Answers   IBM,

---

Can we use unconnected lookup as dynamic lookup?

1 Answers   TCL,

---

Can we take report on Excel in Business Objects?

6 Answers   Business Intelligence Analytics, Oracle,

---

---

HOW TO CREATE THE HEIRARCHY IN WEBI OR DESKI NOT IN UNIVERSE LEVEL?

5 Answers   HCL,

---

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

7 Answers  

---

when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report

2 Answers  

---

How were the reports scheduled and how to resolve unexecuted documents?

0 Answers  

---

what is a Micro cube?

5 Answers   TCS,

---

Explain the SQL Queries activated to data base from Data provider in BO ?

1 Answers   Polaris,

---

How to create an popup in the WEBI report if the report is showing partial result?

2 Answers   Banking, IBM,

---