Partial relation emp-get the details people with min salary, Database Management System

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

Example: Get the details of the people having the minimum salary.

 SELECT ENAME, JOB, SAL

FROM EMP

WHERE SAL = ( SELECT MIN (SAL) FROM EMP);

Output:

ENAME

JOB

SAL

Nirmal

MANAGER

2975

 

Posted Date: 3/11/2013 3:39:15 AM | Location : United States







Related Discussions:- Partial relation emp-get the details people with min salary, Assignment Help, Ask Question on Partial relation emp-get the details people with min salary, Get Answer, Expert's Help, Partial relation emp-get the details people with min salary Discussions

Write discussion on Partial relation emp-get the details people with min salary
Your posts are moderated
Related Questions
Problem Explain at least five relational algebraic operators with a suitable example. Note: All the above descriptions should be done by taking at least two examples from ou

Question 1 Suppose the employee employee id, name, designation, salary, attendance and address of any employee has to be stored in a database. You can store these data in a sequen

What is a Phantom Deadlock? In distributed deadlock detection, the delay in propagating local information might cause the deadlock detection algorithms to recognize deadlocks

What are the several forms of identity? a) Value b) Name c) Built-in

What is inheritance? Define it in detail?  Inheritance Inheritance can be at the levels of types, or at the level of tables we first consider inheritance of types, then i

Use a Set operator to create a list of academics who have written or co-written less than 5 papers and also have greater than 3 interests. List their academic number in the output.

1. Create a subroutine that does the remote blast on the file protein.fa. 2. Pass that returned files from the blast to another subroutine that parses the output and sends it to

client server architeutre

The cross-section of twisted pair The cross-section of each and every strand of the twisted pair is π/4 square mm. A 10-km length of this type of material, with two strands per

Define Direct file organization? The direct file organization is employed to enhance the performance in accessing the records than sequential file organization. In direct file