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

Insert - referential integrity, The insertion of a tuple in the aim of refe... The insertion of a tuple in the aim of reference does not cause any destruction. Though, insertion of a tuple in the relation in which, we has the foreign key, for instance, in ASS

What does the cardinality ratio specify, What does the cardinality ratio sp... What does the cardinality ratio specify? Mapping cardinalities or cardinality ratios state the number of entities to which another entity can be associated. Mapping cardinaliti

Fundamental operations that are regular to mysql programs, What are the thr... What are the three fundamental operations that are regular to MySQL Programs? a) Establishing a connection to the MySQL server b) Choosing a database. c) Disconnecting fr

What is disadvantages of dbms, What is Disadvantages Of DBMS ? 1. Cos... What is Disadvantages Of DBMS ? 1. Cost of Software and Hardware and Migration - A important disadvantage of the DBMS system is cost. 2. Reduced Response and Throughpu

What are referential integrity constraints, What are referential integrity ... What are referential integrity constraints? A value that appears in single relation for a given set of attributes also appears for a particular set of attributes in another rel

Tour Operator Agency Database , #A multinational tour operator agency has g... #A multinational tour operator agency has gained new business growth in the North American market through the use of social media. Its operation has expanded by 50% within six mont

Multiple column queries-syntax, Multiple column Queries: Syntax: ... Multiple column Queries: Syntax: SELECT COLUMN1, COL2,...... FROM TABLE WHERE (COLUMN1, COL2, ...) IN (SELECT COLUMN1, COL2,....  FROM TABLE WHERE );

What is nested relational model, What is nested relational model? The n... What is nested relational model? The nested relational model is an extension of relational model in which domains might be either atomic or relation valued.

What is called bit-level striping, Normal 0 false false fal... Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Explain the functions trim-length-count in oracle, Explain the following fu... Explain the following functions of Oracle with suitable examples: (i) To_Char( ) (ii) Count( ) (iii) Trim( ) (iv) Length( ) Ans: (i) To_char( ): The TO_CHAR function conver

Write Your Message!

Name