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

What disadvantage of odbc does ole db overcome, What disadvantage of ODBC d... What disadvantage of ODBC does OLE DB overcome? By breaking the features and the methods of a DBMS into COM objects, OLE DB characteristic overcomes a main disadvantage of ODBC

ERD, #question.ERD of any car #question.ERD of any car

Conflicting operations in schedule, Conflicting Operations in Schedule: ... Conflicting Operations in Schedule: The three simple ways of interleaved instruction implement of transactions T1 and T2. Please note that in the following tables the first col

Case tools, explain at least five widly used case tools explain at least five widly used case tools

Explain the term- query, Explain the term- Query. Queries are used to re... Explain the term- Query. Queries are used to repossess and show specific records in a table. They can also be used to show specific fields of specific records, which meet the co

List and describe the different types of indexes, Question 1 Indexes are o... Question 1 Indexes are ocasionally defines on a single field of a file called an indexing field. List and describe the different types of indexes Question 2 Consider a book i

What is odbc, What is ODBC ? ODBC - Open DataBase Connectivity which i... What is ODBC ? ODBC - Open DataBase Connectivity which is also denoted by ODBC enable the integration of SQL along with a common-purpose programming language. ODBC expose data

Explain the strategy of database planning, Explain the Strategy of Databas... Explain the Strategy of Database Planning ?

Characteristics, what are the main characteristics of database what are the main characteristics of database

What do you understand by a view, What do you understand by a view? What do... What do you understand by a view? What does WITH CHECK OPTION clause for a view do? - A view is a virtual table which comprises fields from one or more real tables. - It is

Write Your Message!

Name