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

How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

0 Answers

What is ment by For each For all function. In which case we use the option in BO?

2 Answers IBM, TCS,

Is import wizard, report conversion tool, report comparison tool, security viewer ---- where all r migrating tools. whether all the tools available in BOXIR2? ..

2 Answers

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

if the project is assigned for you and the client said yo wait for a month,What will you do in that time?

1 Answers

Explain how to schedule the report in b.o?

0 Answers

Can anybody tell me the difference b/w canned and adhoc reporting?.

5 Answers

Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

0 Answers

WHAT IS SYNCHRONIZATION IN BOXI?

2 Answers HCL,

Are you in Developing or Support in BUSINESS OBJECTS. What is the difference? what are the responsibilites in both?

2 Answers CSC,

What is diff between InfoView and Zero BOAdmin (ZABO)?

2 Answers Nucleus Software,

I HAVE MONTHS AS DEC,JEN,MAY,APRIL... WHICH PROMPT IS USED TO GET REPORT IN SEQUENCE?

2 Answers Patni,

For more Business Objects Interview Questions Click Here