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

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 to connect the hyperlink in webi reports?

7 Answers   TCS,


if we run a report it is taking so much time to display the report,what to do to increase th performance of the report

3 Answers  


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  


what is the difference b/w the refresh and buffered data?

0 Answers  


what are the day to day activities of BO administrator ?

0 Answers   TCS,






What is the pragma?

2 Answers  


WHAT PROBLEMS ARE NOT KNOWN WHILE PERFORMING INTEGRITY CHECK?

2 Answers   PCS,


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

1 Answers   Fidelity,


Briefly describe the steps you would take to use an Excel file as data to join a Business Objects data provider in a report? Thanks in advance....

2 Answers  


Explain is data mart?

0 Answers  


How we can resolve the loops by using the Aggrigate Awareness?

1 Answers   Hexaware,


normally we get many contexts when resolving loops or traps,how do u take them to reports.

2 Answers   Wipro,


Categories