Interested to Buy Any Domain ? << Click Here >> for more details...
There are 2 tables:
EMP : EmpId, Ename, Sal, DeptId
DEPT : DeptId, Dname
Write a query to find out emp names and their department names. if any emp has null in Deptid the it shows
?No Department?.
Write a query to find out those department names which
has no employee.
Write a query to find out those employees whose salary
is greater than their department?s average salary.
- 1 Answers
- 6342 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / humera
Answer Q # 37
select e.ename,d.dname from emp e left outer join dept d on
e.deptid = d.deptid
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
I'm new to ABAP. What is Module pool in SAP?
A good website has the following conditions It should be interactive. It should contain at least 20 images. Title cannot be null and should contain at least 10 letters other than spaces and hyphen (-). The keywords should contain atleast three among the following list : "design", "Graphics", "lovely", "beautiful", "amazing" and "mesmerising" Write a method: boolean isGoodWebsite(boolean isInteractive, int numOfImages, String title,String keywords[]) isInteractive whether the site is interactive or not numOfImages Number of images on the website title Title of the website keywords Array of keywords in the website.
qtp 9.2 14 days demo version was expired.I uninstalled how to reinstall this again
the systematic access of small computers in a distributed data processing system is referred as?
how can we maintain the previous version scripts to new version.
a characteristic of a multiprogramming is? a.simultaneous exe of pgm instr 4m 2 appli b.concurrent processing of 2 r more prgms c.multiple cpu s d.all the abov
shall we execute our java programmes in jre
Find out the roles which gives access to all tables in SAP? Thanks in advance.
5. How do you round the addition or subtraction of two numbers in assembler?
Hi All, Can any one please send me the difference between informatica 7i and 8i versions, Thanks in advance. vinod
What's the difference b/w Table & Templete in Smartform?
which worker is involved in all the phases of SDLC?
i am getting the error while compiling my cics program with including db2 dclgen member it is showing that ur dclgen member not including and all the host variables are undeclared
in IBM PC -AT.WAT AT REFERS TO?
Given an array of size n+1 which contains all the numbers from 1 to n.Find the number which is repeated in O(n) time.How do you proceed with the same with floating numbers from 0 to 1 instead of 1 to n?
