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
- 4 Answers
- 6387 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / amutha
select empid,name,depno from table1,table2 where table1.deptno=table2.deptno(+)
| Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
Explain when to use local filter and when to use global filter?
How to restrict password to a user while sending a document in .pdf format
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
What are the steps to be taken to schedule the report?
8. How much supervision have you typically received in your previous job?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
What are all difference between business objects 6.5 and xi r2?
How many universes can be created in a project?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
can anybody tell me about complicated object you have created
Explain how to schedule the report in b.o?
What are the data types present in bo? What happens if we implement view in the designer and report?
What is the dense rank?
