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
Which is another name for weak entity? Child is another name of weak entity.

What is the main goal of RAID technology? Describe the levels 1 through 5. RAID stands for Redundant Array of Inexpensive (or sometimes "Independent")Disks. RAID is a met

Determine the Persistent object Persistent object can be stored in one of the following: Files Cheap, permanent, simple storage Low level (Write, Read) Ap

What Count function return in SQL? Count function within SQL returns the number of values. (Count function counts all the not null values in the exact column. If we need to cou

To eliminate duplicate rows (distinct operator)  Example: SELECT DISTINCT DEPTNO FROM EMP;

Develop C# schoolproject ASAP Helping me with schoolproject. The project is prepared in C# and haves a database connection. We have some small issues asking up data from t

Describe the advantage of State chart Diagram A state chart represents a state machine, emphasizing flow of control from one state to other. A state machine is a behaviour whi

What does the extract statement do in extract datasets? The data is written to virtual memory by extract commands.

The basic merits of decomposition. The Advantages of Decomposition 1.  Separate person can work on each subsystem. 2.  A particular software engineer can specialize in a

Three Level Architecture of DBMS or Logical DBMS Architecture The logical architecture defines how data in the database is perceived by users. It is not deals with how the da