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 5526Post New Oracle Programming Languages AllOther Interview Questions
Which function to use to compare the application date with system date?
In which view headers and footers are visible?
Explain some disadvantages to manual software testing?
how do u define in ur build.xml If I need to execute a task before executing my task?
Why hashmap is used in java?
What is difference between the "throw" and "throw ex" in .net?
How to set fixed width in particular
Can a private method be declared as static?
Explain pointers in go?
Can Somebody tell me what should i do if i hadn't filled form for the next mahagenco exam for any new vaccency. if any one can provide me contact email to mail some one at mahagenco office, please mail me if any thing you can do on pratikgupta05yahoo.in
Tell me what is reversing journal entries?
Is swift faster than c++?
What is get_instance in codeigniter?
What is 'commit' command in perl?
Difference between error and exception