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
6408 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 to link 3 fact tables

1 Answers

What is the differrence between prompt & @prompt? What is the differrence between Xcelsius & Web-I Report?

3 Answers Wipro,

what is difference between WEBi Report and Crystal Report?

3 Answers Cognos, Nucleus Software, Red Cross,

HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?

2 Answers Polaris,

What is the difference between absolute and relative div positioning?

0 Answers

What is the report extension in webi and deski

2 Answers

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

What is the difference between derived table and views? which one gives better performance?

2 Answers TCS,

how can we retrieve particular number of rows from data ware house?for EX: my report want to displayed with 10 records in a report??how

3 Answers Keane India Ltd,

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

0 Answers

What are the types(Specific Names) of Scheduling in BO?

3 Answers Cap Gemini,

i want to take a report 10 records per page. How to take it? is there any paging option in BO?

5 Answers Cap Gemini, IBM,

For more Business Objects Interview Questions Click Here