Employee 7566 salary is extra than salary of employee 7788, Database Management System

Example: -Show the employees whose job title is the similar as that of employee 7566 and salary is extra than the salary of employee 7788.

Let consider the given partial relation EMP. Let us make some sub-queries for them

EMPNO

ENAME

JOB

SAL

DEPTNO

7566

Nirmal

MANAGER

2975

10

7788

Kailash

ANALYST

3000

10

7839

Karuna

PRESIDENT

5000

20

7902

Ashwin

ANALYST

3000

20

7905

Ashwini

MANAGER

4000

20

 

SELECT ENAME, JOB

FROM EMP

WHERE JOB =   (SELECT JOB  

                            FROM EMP

                            WHERE EMPPNO = 7566)

                 AND SAL > (SELECT SAL

                                       FROM EMP

                                       WHERE EMPPNO=7788);

 

Output: Job title for the employee 7566 occurs to be 'MANAGER')

ENAME

JOB

Ashwini

MANAGER

Posted Date: 3/11/2013 3:42:43 AM | Location : United States







Related Discussions:- Employee 7566 salary is extra than salary of employee 7788, Assignment Help, Ask Question on Employee 7566 salary is extra than salary of employee 7788, Get Answer, Expert's Help, Employee 7566 salary is extra than salary of employee 7788 Discussions

Write discussion on Employee 7566 salary is extra than salary of employee 7788
Your posts are moderated
Related Questions
Consider the following database schema: STAFF(StaffNo, fName, lName, Position, sex, dob, branchNo) BRANCH(BranchNo, Street, City) Assume the following for the above database

design a generalization specialization hierarchy for a motor vehicle sales company. the company sells motorcycles, passenger cars, vens and buses.

What is known as a search key? An attribute or set of attributes used to look up records in a file is known as a search key.

I need some help with my normalization database homework.

Saving Derived Attributes to Avoid Re-computation   As discussed, "redundancy means duplication of exact data". But, if multiple copies of same data are present in the system,

Explain the relevance of Data Dictionary in a Database System? Data dictionary is a database in its own right residing on the disk that consist of Meta data which is = Data abo

List the set operations of SQL? 1) Union 2) Intersect operation 3) The except operation


need to get answer for questions 3&4 on this page in part 1

Explain the term - Adjustment of inheritance The inheritance can be enlarged as object design progresses by changing class structure. The designer should do: i) Adjust or r