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
8065 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's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

0 Answers HCL,

how to optimize the query perfomance in b.o?

1 Answers TCS,

when you have three fact table and there is no relationship between them. How you will tackle the issue.

2 Answers BMC, TCS,

what r the universe connection types?

4 Answers

wat is the difference between full clinet report and thin client report?wat is the difference between desktop intelligence and web intelligence?

3 Answers Target,

how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statement we can copy it and paste it in TOAD or someother tools to test it but if we have multiple sql statements in a single query????

1 Answers IBM,

tell me about aggregate awareness in detail?

2 Answers Cap Gemini,

Explain the difference between compatible and incompatible objects?

0 Answers

if we shortcut join between two tables what will be the output?that it will give all columns or same columns?

2 Answers

What are the Users and User groups?

2 Answers Wipro,

How many universes will run maximum in single project

1 Answers HP,

Instead of cms which server you have to use?

2 Answers CTS,

For more Business Objects Interview Questions Click Here