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
- 6471 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 |
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,
can we use commit,rollback in triggers and how?
code for connection from windows forms to sql server
Why multiple inheritance is removed in java?
what is delimiter in sas ?
What is SOLID Principle in Programming Language?
purpose of abstraction and interface
Always use scope terminator like End-If with IF, End- Evaluate with Evaluate statement.Can somebody explain me the detail logical explanation?
What is the purpose of <Trigger> element of <updatePanel> in Ajax
how much fee for deccan soft institute .how to block seat for sandeep sir class reply soonnnn
if there are n nodes in a binary tree, how many null pointers are there?
___ method used to move a recordset pointer in nth position in DAG.
C 
