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
- 8221 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can we create universe with no cache??
How can you first report in Business Objects by using broadcast agent?
Explain about a tricky situation for which you found a very simple solution?
how to prepare the documentation in business objects and where to get the requirement?
Explain what are the measure objects?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Differences between business objects and web intelligence reports?
U r project in which stage in implementation?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What we need to discuss with designer before starting the universe designing.
How to generate the report from excel sheet?
Explain what would you consider as your biggest achievement and why?
Which versions are used in the bo dashboard work?
What is Indexing? how did u implement indexing?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
