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

while migrate bo 5.1 report into boxir2 ,what are the problems faced

2 Answers

There is one report running and a user wants to know whether data is from detail table or summary table. what is your approach?

1 Answers

explain about Prompt with example?

4 Answers CSC,

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

0 Answers BMC,

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

2 Answers Nucleus Software,

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

0 Answers

how we improve the performance of report and universe?

4 Answers Accenture, IBM,

When N reports are scheduled for N users, How does the BCA process /know to which user the report needs to be sent?

4 Answers Wipro,

when I am trying to schedule the report its running faster then I tried to run it manually?? why is it so that there is difference of time between scheduling and manual run for report

2 Answers

Say, the query gets executed and we got the results. In case if we have a large number of rows, how can we know the exact no of rows returned?

6 Answers

please anyone explain the equi join,outer joi(right outer join and left outer join),theta join and self join with database tables.

2 Answers Wipro,

Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

0 Answers TCS,

For more Business Objects Interview Questions Click Here