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

Oracle, List and explain the memory constructs of the Oracle 12c databases?... List and explain the memory constructs of the Oracle 12c databases?

What is a name, What is a Name? A user-supplied name is used for identi... What is a Name? A user-supplied name is used for identity. This form of identity is used for files in file systems. The user gives every file a name that uniquely identifies it

Unnormalize form, employee(empid,empname,dept,telno,mobno, add,sssno,tinno,... employee(empid,empname,dept,telno,mobno, add,sssno,tinno,WEdates,WEcomp,WEadd,WEpos,WEres) this is a employee record which is need to be normalize.the WE means work experience

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

Data analyzing and desing, Critically explained the benefits and limit... Critically explained the benefits and limitations of different database technologies with proper examples

What is a transaction? and how does it differs from update, wh wh

What is data link layer, what is data link layer what is data link layer

Clustering indexes, Clustering Indexes It may be an excellent idea to k... Clustering Indexes It may be an excellent idea to keep data of the students in the order of the programme they have registered as most of the data file accesses may need studen

Give some encryption techniques, Give some encryption techniques? A)  D... Give some encryption techniques? A)  DES  B) AES  C) Public key encryption

Define the wait for graph, Define the Wait for graph Ans: The wait-for-... Define the Wait for graph Ans: The wait-for-graph is a directed graph and consist of nodes and directed arcs; the nodes of the graph are active transactions. An arc of the grap

Write Your Message!

Name