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
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Answer / amutha
select empid,name,depno from table1,table2 where table1.deptno=table2.deptno(+)
Is This Answer Correct ? | 3 Yes | 10 No |
how to connect the hyperlink in webi reports?
if we run a report it is taking so much time to display the report,what to do to increase th performance of the report
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
what is the difference b/w the refresh and buffered data?
what are the day to day activities of BO administrator ?
What is the pragma?
WHAT PROBLEMS ARE NOT KNOWN WHILE PERFORMING INTEGRITY CHECK?
What problems you have faced while creating an universe? tell me an incident and how you went about solving it?
Briefly describe the steps you would take to use an Excel file as data to join a Business Objects data provider in a report? Thanks in advance....
Explain is data mart?
How we can resolve the loops by using the Aggrigate Awareness?
normally we get many contexts when resolving loops or traps,how do u take them to reports.