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

Describe query evaluation engine, Describe Query evaluation engine? Que... Describe Query evaluation engine? Query Evaluation engine: Vehicle executes low-level instructions obtained through the DML compiler. The Storage Manager Components gives in

Replication-design of distributed databases, Replication : It is definite a... Replication : It is definite as a copy of a relation. Every replica is stored at a dissimilar site. The alternative to replication is to store only single copy of a relation which

Database backup, Discuss the importance and characteristics of database bac... Discuss the importance and characteristics of database backup and recovery procedures, then describe the actions that must be detailed in backup and recovery plan

Explain thomas write rule, Explain Thomas' Write rule.  Show how it is diff... Explain Thomas' Write rule.  Show how it is different from timestamp ordering protol Ans: In timestamp-based concurrency control the thomas Write rule is a rule. Given a Timest

Er diagram, Design a generalization–specialization hierarchy for a motor-ve... Design a generalization–specialization hierarchy for a motor-vehicle sales company. The company sells motorcycles, passenger cars, vans, and buses. Justify your placement of attrib

DW Job Scheduling, Define a job scheduling strategy that will meet business... Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pictori

Mis, explain three types of internet risks to the consummers whent he busin... explain three types of internet risks to the consummers whent he business system is data dependent. how can we minimise these risks

Schema, difference between internal schema and external schema in DBMS difference between internal schema and external schema in DBMS

Question, I want to buy this but I want to see a couple sample questions fi... I want to buy this but I want to see a couple sample questions first. http://www.expertsmind.com/library/what-happens-to-rms-error-for-the-training-data-set-51564843.aspx

Hangman, a method named WonGame that checks each letter in the word is matc... a method named WonGame that checks each letter in the word is matched by its label

Write Your Message!

Name