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

Northwind Pty Ltd sells a variety of food products throughou, i want help t... i want help to complete my task

Differance between internal and external schema, Differance between interna... Differance between internal and external schema? Internal and external schema: Internal Schema • Describes the physical storage structure • Uses a physical data model External

What is data integrity, What is data integrity? Ans: It is the data con... What is data integrity? Ans: It is the data consisted of in database that is accurate and consistent.  (Data integrity means that the data should be valid as per to the give

Super market, .. ..

What is the difference between link and reference, What is the difference b... What is the difference between link and reference? The fundamental difference between links and references is that links are symmetrical on the other hand references refer only

Define average seek time, Define average seek time. The average seek ti... Define average seek time. The average seek time is the average of the seek times, calculated over a sequence of random requests.

Search the name department number and salary of employees , Example : Searc... Example : Search the name, department number and salary of employees drawing minimum salary in that department. SELECT ENAME, SAL, DEPTNO  FROM EMP WHERE SAL IN (SELECT MI

Aggregation, aggregation aggregation

Determine the steps of path in association network, Determine the steps of ... Determine the steps of path in association network You can analyse use of paths in association network in the following steps:  Examine every operation and see what asso

List the set operations of sql, List the set operations of SQL? 1) Unio... List the set operations of SQL? 1) Union 2) Intersect operation 3) The except operation

Write Your Message!

Name