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
What is view in SQL? How is it defined? Any relation that is not part of the logical model, but is made visible to a user as a virtual relation is known as a view. We descri

Relationship between Security and Integrity: Database security usually refers to access, while database integrity refers to avoidance of accidental loss of consistency. But usually


examples of fields in a database

Differentiate between a subquery and a join If we need to acquire information from one or more tables after that either subquery or join can be used. If the columns which are t

Objectives Define the terms RECOVERY and INTEGRITY; Define Recovery Techniques; Explain Error and Error detection techniques, and Define types of Authorisation.

What is RDBMS? Relational Data Base Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships may be formed and

What is ICR? A. ICR (Intelligent Character Recognition) is a technology that gives scanning and imaging systems the ability to identify images of hand-printed or script charact

What are the time stamps associated with each data item? W-timestamp (Q) denotes the largest time stamp if any transaction that implemented WRITE (Q) successfully. R-timesta

What is called remapping of bad sectors? If the controller detects that a sector is injured when the disk is initially formatted, or when an attempt is made to write the secto