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 do you understand by a view? What does WITH CHECK OPTION clause for a view do? - A view is a virtual table which comprises fields from one or more real tables. - It is

Differentiate between a Global and a Local temporary table? - A local temporary table exists only for the duration of a connection or if defined inside a compound statement, fo

Question: Describe briefly the three parts of the Relational Model. (a) The term integrity refers to the accuracy or correctness of the data in the database. Define the fol

What is Explicit update In explicit update, each derived attribute is defined with respect to one, or more fundamental base object(s). The object designer determines that de

What is meant by computing the closure of a set of functional dependency? The closure of F denoted by F + is the set of functional dependencies logically implied by F.

Domain Constraints Domain constraints are primarily formed for defining the logically correct values for an attribute of a relation. The relation allows attributes of a relatio

Class Diagram A class diagram is required to support functional necessity of system. In a static design view, class diagram is used to model vocabulary of the system, simple c

Explain concept of inheritance with support of suitable example. Inheritance Inheritance is one of milestone of object-oriented programming language as it allows a creati

What disadvantage of ODBC does OLE DB overcome? By breaking the features and the methods of a DBMS into COM objects, OLE DB characteristic overcomes a main disadvantage of ODBC

Explain Stand Alone Query Language in details? Stand alone Query Language - The query language that can be used interactively is known as stand alone query language. It does no