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
- 6387 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 |
Hi all... I had completed MSC(Computer) and had join the construction company based on sap.they want me to work on abap.but software company is totally different from construction company and they want me 2 grasp it as fast i can.i am finding it difficult.what should i do??????
Find out the list of roles which gives access to GUI activities? thanks in advance
Find out the roles which gives access to all tables in SAP? Thanks in advance.
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
what is the difference between primary key and unique key?
How to convert numeric value into words in c#????plz suggest me the coding of this question???
Find out the list of authorization objects which contains activity as a field? Thanks in advance.
What is good attributes of Programming language ?
Can we write a method in JSP.If so how?
How many forms can you create in a Visual Basic 6 Standard EXE project? Is there any limit on that?
How to find out the user exit for va01.
why we need to take u?
C 
