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
The H. I. Topi School of Business operates international business programs in 10 locations throughout Europe. The school had its first class of graduates in 1965. The school keep

What is Hierarchical DBMS In HDBMS, data is structured in a tree like manner. There is a parent-child relationship between data items and the data model is very suitable for re

What is a database? At any given time, they're storing a tremendous amount of information - inventory, in the case of Amazon, messages and interrelationships in the case of Tw

The Concurrent Transactions  Almost every commercial DBMS support multi-user environment. Therefore, allowing multiple transactions to proceed concurrently. The DBMS must make


Normal 0 false false false EN-IN X-NONE X-NONE

What are the advantages of by using an index and what are its disadvantages ? In difference, if the search key of a secondary index is not a candidate key, it is not sufficient

What is vertical fragmentation? Vertical fragmentation divides the relation by decomposing the scheme R of relation r.

What are the two approaches to store relations in distributed database? a) Replication b) Fragmentation

intent locking