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
- 5550 Views
- Oracle, I also Faced
- E-Mail Answers
Answer / 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 |
how pseudo column works?
How does the TCP handle the issue of multiplexing?
3. What is the difference between testing and Quality Assurance?
Which tag is used to break a line
along with oracle which language will be beneficial to have knowledge with,java,.net,since i m doing oracle have appeared for 8th sem BEIT,plz suggest
suppose we have ten members of a physical file but we want the output of last 5 members only.how to achieve that?
hi this is uday i want prepare for nic exam if any one have previous question papers please send me or atlest guide me how to prepare my ID is udaykiran4u@in.com
the channel in the data communication model can be? option a.postal mail serv. b telephon lines c.radio signals d. all the above
2 Answers iNautix, National Investment Commission,
what are the differences between CONS, LIST, and APPEND
2.Different data types in C? and its value and range?
cobol is execution r not without jcl
how many keywords are present in "c"?
18 Answers Assurgent, Cynosure Software, IBM,
C 
