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
8100 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

Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

0 Answers BMC,

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

0 Answers

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

2 Answers iNautix, TCS,

1. what is import wizard and its purpose ? 2. what is publishing wizard and its purpose ?

4 Answers KPIT, TCS,

What is the difference between Thin client & thick client?

5 Answers

what are the types of universes? what is the difference between metri universe and simple universe? in what context we use metric universe?

4 Answers Fujitsu, Virtusa,

what is difference between global filter an query filter in web intelligence?

3 Answers

Can we get the data from two different databasess in reporting level?

1 Answers Infotech,

What problems you have faced while creating an universe? tell me an incident and how you went about solving it?

1 Answers Fidelity,

Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

0 Answers

How to sheduling the report ? What is the need of it?

2 Answers Infotech,

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

2 Answers

For more Business Objects Interview Questions Click Here