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

WHAT ARE THE TYPES OF UNIVERSES?PLZ EXPLAIN IT

9 Answers Business Intelligence Analytics, SRA,

What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

0 Answers

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

0 Answers

I have one vertical table and in that table there are 10 rows. I want to add one row between 4-5 row. How it possible in WebI.

3 Answers

How to execute the plsql procedure from the report by clicking with mouse?

0 Answers

what is the syntax for aggregate awareness?

3 Answers Exilant, i-Tree, Wipro,

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

3 Answers iFlex,

What is the profile and package?

0 Answers

What is the sheduling the report? What is the need of sheduling the report?

1 Answers Wipro,

How to change font color of values in hyperlinked columns?

4 Answers

What is casual dimension?

4 Answers

What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

0 Answers Infosys,

For more Business Objects Interview Questions Click Here