Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8066 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
explain in detail about type 3?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain how we drill up week to month?
Differences between business objects and web intelligence reports?
What Is Snow Flake Schema?
What three things do you consider to be the most important factors for a manager?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What are all difference between business objects 6.5 and xi r2?
What are the steps to be taken to schedule the report?
Explain in detail about type 2(scd),
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
What is the difference between condition & filter?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
