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
- 6477 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 to print No.of.rows affected after updation using ADO.Net
what are stubs related to foxpro?
What is the entry point function of a DLL?
How to set fixed width in particular <td> in html? if i type more character in this <td> it will not push near <td>. this is my question. can u tell me the answer...
9.Difference between even and odd signals?explain with the diagram?
how do you generate source code for the automatic generation for receipt number
What is the difference between CLEAR & RESET and OPEN & CLOSE OPCOEDS(USING RPG/400).wheare we can use this?can any body tell me in real time senario with example please?
Which language they use during interview?
0 Answers State Bank Of India SBI,
In staad pro, how can we design ROOF SLAB?
what type of exceptions & problems are faced in production time at java technology?
Can anyone provide as400 training material or any institute in bangalore for as400 training
Hi guys... I have one doubt ..Exception is a runtime error then why we have checked exception... Thanks in advance
C 
