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
- 5548 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 |
which one is the best practice using synchronization method or synchronization block
Difference between interface and abstract class?
Describe the difference between Interface-oriented, Object-oriented and Aspect-oriented programming
Find out the list of roles which gives access to GUI activities? thanks in advance
What's the difference b/w Table & Templete in Smartform?
Diff between IF and where ?
what is difference between IF-ELSE-ENDIF and IIF.
How to change the color of a cell or a row in a datagrid on mouse hover using javascript/.net
Corillian's product is a "Component Container." Name at least 3 component
Delta 5 weight scale not connect with oracle application what i can do?
How does the type system works when there is interoperability between a COM and .Net, i mean what exactly happens there
What is the difference b/w Object base and object oriented programming?
C 
