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
- 7892 Views
- IBM, I also Faced
- E-Mail Answers
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 restrict null values in webi report?
HOW TO SPOT A HIERARCHY?
Explain how we drill up week to month?
Explain the difference between compatible and incompatible objects?
how we improve the performance of report and universe?
When N reports are scheduled for N users, How does the BCA process /know to which user the report needs to be sent?
how we send repotrts/documents to end user
how to create dashboard reports
What is the difference between absolute and relative div positioning?
Analysis in business objects?
Where will you find the address of repository in Business Objects?
Give some information on report bursting?
Teradata 
