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

Explain clustering file organization, Explain Clustering file organization ... Explain Clustering file organization (i) Determine if a record of file is physically ordered on a nonkey field - that does not comprise a different value for each record - that

OLD HOME POLICIES, Write an sql statement to find what is the percentage of... Write an sql statement to find what is the percentage of home policies which are from the state of Arizona out of all Home policies by Policy Value.

Query optimization, what is meant semantic query optimization? how does it ... what is meant semantic query optimization? how does it differ from other query optimization techniques?

Normalization database, I need some help with my normalization database hom... I need some help with my normalization database homework.

What is enterprise resource planning, What is Enterprise Resource Planning ... What is Enterprise Resource Planning (ERP), and what kind of a database is used in an ERP application? Enterprise Resource Planning (ERP) is an information system used in manuf

Database structures, 3 assignments combined in 1 3 assignments combined in 1

Define a relation in dbms, Define a relation ? Relation - A relations... Define a relation ? Relation - A relations is a named two-dimensional table of data. Mathematically, a relation can be described as a subset of the cartesian product of a lis

Which language used in application programs for request data, Which languag... Which language used in application programs to request data from the DBMS is referred? Language which is used in application program is DML to request data from the DBMS is ref

Illustrate the term- abstracting out common behaviour, Illustrate the term-... Illustrate the term- Abstracting Out Common Behaviour Inheritance is not every time recognised during analysis phase of development, thus it is necessary to re-evaluate object

Explain candidate key and super key, Explain Candidate Key and Super Key ... Explain Candidate Key and Super Key A super key is a set of one or more than attributes that, taken collectively, permits us to identify uniquely a tuple in the relation. Wher

Write Your Message!

Name