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 6360Post New Oracle Programming Languages AllOther Interview Questions
What happens in insertion sort?
#include main() { int *p, *c, i; i = 5; p = (int*) (malloc(sizeof(i))); printf(" %d",*p); *p = 10; printf(" %d %d",i,*p); c = (int*) calloc(2); printf(" %d ",*c); }
Maria on the moon are?
What is the full form of vscp?
What is the relationship between microsoft sharepoint portal server and microsoft windows services?
List out five keywords related to exception handling ?
Define role of veracity in big data?
Explain different types of reports?
What is the use of worm gears?
Why set do not allow duplicates in java?
Which transaction is used to create and configure trusted rfc?
How do I separate first and last names in excel 2016?
What is the difference between vbscript and vba?
What are Namespaces?
When is a 'generate error' activity useful?