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
- 7970 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
What would you consider as your biggest achievement and why?
Can you please send me the migration related issues .
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
what is universe null
What is the profile and package?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
Difference between zabo and webi?
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 about a time when you discovered a more efficient way to do a work task?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
What is the difference in creating filters in designer and business objects?
How to schedule the report in b.o?
