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
- 6428 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 |
What do you mean by an array ? explain with an example
what is the software to run the GSM gate opener program
can we allocate memory for interface? if no then why?
Write a program to calculate the following i want a Java program for this condition 1+4+9+16+….+100 Like this (1^2+2^2) Hint use function pow(a,b)
what is the difference between set and append?
what is the filters in biztakk server? where it can use?
we can use parameters in cl and rpg pgms...etc.in particular i think when we use data area or datastructure or data queue .i think this means which one====in my question...parameters cannot be passed in which one????hope understand my qstn???
What is the requirement in MIMD ?
why we use static with only main()class not with other class
When will you use shell script/Perl ahead of C/C++?
which is the best institute for testing tools in hyderabad?
Given an array of size n+1 which contains all the numbers from 1 to n.Find the number which is repeated in O(n) time.How do you proceed with the same with floating numbers from 0 to 1 instead of 1 to n?
C 
