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
- 6458 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what are other resources are needed for this mantis?
write a query that returns one row for each department and the number of employees in that department. Given two tables EMPLOYEE and DEPARTMENT, where there can be multiple employees per department.
Difference between delegates and Events?
Find out the roles which gives access to all tables in SAP? Thanks in advance.
Q2. A memory location has physical address D5687h. Compute: a. The offset address if the segment number is D445h. b. The segment number if the offset address is B577h.
if 3 duplicate records, by keeping one original and one duplicate record, and how to delete remaining 2 duplicates in sql server 2008
i want to improve my english vocab for racking campus written exam plz tell me best book for prepration......
what is the difference between Windows application and Unix application?
give idea for creating screen in abap
Definition of Singleton Class? what is the Purpose of it? what is the advantage?
A good website has the following conditions It should be interactive. It should contain at least 20 images. Title cannot be null and should contain at least 10 letters other than spaces and hyphen (-). The keywords should contain atleast three among the following list : "design", "Graphics", "lovely", "beautiful", "amazing" and "mesmerising" Write a method: boolean isGoodWebsite(boolean isInteractive, int numOfImages, String title,String keywords[]) isInteractive whether the site is interactive or not numOfImages Number of images on the website title Title of the website keywords Array of keywords in the website.
shall we execute our java programmes in jre
How to use string functions in QTP?give some examples
What are two of your strengths that you will bring to our QA/testing team?
How to connect the .accdb database file of microsoft access to the Visual Basic 6.0 forms?
