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.

What is thin client And thick client..?

2 Answers  

---

Can master data change???if yes then how it'll change.....please explain with example...... thanx

1 Answers  

---

Hi Can anyone tell me what is Divergence in Business Object Universe Designer. Thanks, Sheik

1 Answers  

---

Explain about alerts in bos, under what situation we need to use alerts?

0 Answers  

---

What happens in BO when a user logs in to Infoview and a rich client like webi?

2 Answers   TCS,

---

how to create dashboard reports

4 Answers   TCS,

---

1.what is the use of migration.(converting one version to another) 2. what r the migration issues faced while migrating from Bo5.x to BOXIR2 n how 2 resolve it. 3. provide some .ppt/material to understand abt migration easily.

16 Answers  

---

Explain what is the difference between business requirement document and use case document.

0 Answers  

---

you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment number some of the depatment no of 1st table are not present in table 2 how will you create a report only to get the departments of which excess in table 1

4 Answers   IBM,

---

11.what are the features in BO?

2 Answers   IBM, TCS,

---

Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

0 Answers  

---

What are the Users and User groups?

2 Answers   Wipro,

---