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

Explain the BO Developer WORK FLOW?

3 Answers TCS,

What is the slice and dice?

3 Answers

What is the difference between Report Bursting and Report scheduling?Explain both of them in detail?

1 Answers NSE,

Is it possible to join more than one universe in Business Objects? If its so how is that possible ? thanks in advance for the answers

5 Answers Wipro,

Have you worked with multiple data sources? If yes. How do you link them?

1 Answers

HOW DO YOU SCHEDULE THE REPORTS?

5 Answers

What is the difference b/w breaks and sections

2 Answers IBM,

in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it should be displayed in (yyyy/mmm/dd)format. how could I do this plse send me as soon as possible.

3 Answers

use scheduler to refresh report.....explain please.....

2 Answers

REGULAR CLASSES for OBIEE Reporting(RPD, Answer, BI Publisher) is Starting From Tuesday, 25th Oct, 7:00 AM IST

1 Answers

1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?

3 Answers Wipro,

How to make alternative rows red and green in WebI Report?

3 Answers Accenture, Mphasis,

For more Business Objects Interview Questions Click Here