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
- 8068 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
How were the reports scheduled and how to resolve unexecuted documents?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What is top business?
What is report template in b.o?
Explain the difference between union and group?
How can you first report in Business Objects by using broadcast agent?
what are the tables used in health care domain project and columns used in report?
What is the dense rank?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
Explain the data types present in bo and what happens if we implement view in the designer and report?
What is object stores?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Explain how to execute the plsql procedure from the report by clicking with mouse?
