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
- 8083 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rajesh kumar
select empid,name,depno from table1,table2 where
table1.deptno not in table2.deptno
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Is there any other repository domains rather than universe, security, document?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain what task is 98% of the required work of a business analyst?
Did you face any problems while creating reports? Name? Solutions?
in sap bi we have wad, then why we go for sap bo
What is a bo repository?
What is the difference between business requirement document and use case document.
What are all difference between business objects 6.5 and xi r2?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain what are the steps to be taken to schedule the report?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
What is the difference between user and versatile user?
how to create reports on screech?
