you have two tables table 1 contains emp id,name and deptno and tble 2 contain

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

Question Posted / soni

4 Answers
8115 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment num..

Answer / taruna

The question is 'how to create a report' and not database query!!! We may apply MINUS operator between the two queries in query panel. This will give the difference.

Is This Answer Correct ?

6 Yes

0 No

you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment num..

Answer / vishal

select a.empid, a.name, a.deptno from table1 a, table2 b where a.deptno != b.deptno

Is This Answer Correct ?

8 Yes

6 No

you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment num..

Answer / rajesh kumar

select empid,name,depno from table1,table2 where
table1.deptno not in table2.deptno

Is This Answer Correct ?

5 Yes

3 No

you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment num..

Answer / amutha

select empid,name,depno from table1,table2 where table1.deptno=table2.deptno(+)

Is This Answer Correct ?

3 Yes

10 No

Post New Answer

More Business Objects Interview Questions

Explain the data types present in bo and what happens if we implement view in the designer and report?

0 Answers

WHERE DO YOU USE GLOBAL FILTERS ,EXPLAIN WITH EXAMPLE?

2 Answers PCS,

Explain what task is 98% of the required work of a business analyst?

0 Answers

Can any one say me wat does"maintanence of universe" means wit?

2 Answers Business Intelligence Analytics, NAL, TCS,

What is difference between merged dimension and forced dimension??

1 Answers

What is the difference between Sychronisatio and join?

2 Answers Mind Tree,

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGNING UNIVERSES?

2 Answers

What is the pragma?

2 Answers

The business object 6.5 version is possible for created dashboard reports.if possible how is generated universe to dashboard reports

1 Answers

How to solve the following errors coming in report development? 1.Syntax 2.multi value 3. #Error 4.computation and 5.Objects are not compatible

2 Answers

As im new to BO, tel me 1.How to do migration from BO6.5 to BOXIR2? 2.whats the difference b/w BO6.5 to BOXIR2. 3. whats the way both BO 6.5 n BOXIR2 file storge varies.

5 Answers Cap Gemini,

limitaions of cross tab ?

1 Answers

For more Business Objects Interview Questions Click Here