Let us now talk about the relational operations:

SELECT

The select operation is used to select few specific record from the database based on different criteria, This is a unary operation mathematically denoted as σ

Syntax:

σ  (Relation)

The Boolean expression is specified in is made of a number of clauses of the form:

or

Comparison operators in the set { ≤, ≥, ≠, =, <, <} apply to the attributes whose domains are ordered value like as integer.

---

Related Discussions:- Relational operations

Process to find the non-concurrent objects, Process to find the non-concurr... Process to find the non-concurrent objects Once we find out non-concurrent (mutually exclusive) objects, we can fold all objects together in one thread of process or control. O

Designing the hierarchy of a ldb?, What sorts of tables one can se in desig... What sorts of tables one can se in designing the hierarchy of a LDB? Tables, which are having Foreign Key relations.

Dataware house, multidimensional data model multidimensional data model

Assigning responsibility for operation, Assigning Responsibility for Operat... Assigning Responsibility for Operation Many operations might have obvious target objects, but some of these operations could be used at numerous places in an algorithm, by one

Pl/SQL, I need solution of the question posted at http://www.expertsmind.c... I need solution of the question posted at http://www.expertsmind.com/questions/sql-query-for-testing-triggers-and-stored-procedures-30140149.aspx

What is advantage of two-way association, What is advantage of two-way asso... What is advantage of two-way association? Two-way association advantages are following: a) Independent of the classes. b) Useful for existing predefined classes that are

What are the several kinds of the update operations relation, What are the ... What are the several kinds of the update operations on relations? Also explain the constraints on these update operation. Give instance in support of your answer. There are th

Er digrams, what is er digram given that example of hospital,bank and libra... what is er digram given that example of hospital,bank and library er digram.

List the drawbacks of relational database system, List the drawbacks of rel... List the drawbacks of relational database system A) Repetition of data B) Inability to s certain information.

What is the meaning of data independence, What is the meaning of Data indep... What is the meaning of Data independence? Data independence means a programs that are not dependent on the physical attributes of data and a programs that are not dependent on

Write Your Message!

Name