What is a select operation, Database Management System

What is a SELECT operation?

The select operation selects tuples that please a given predicate. We use the lowercase letter σ to denote selection.


Posted Date: 6/1/2013 3:32:04 AM | Location : United States

Related Discussions:- What is a select operation, Assignment Help, Ask Question on What is a select operation, Get Answer, Expert's Help, What is a select operation Discussions

Write discussion on What is a select operation
Your posts are moderated
Related Questions
Explain Relational model and their use in DBMS? Relational Model - The relational model was first introduced through E.F. Codd of the IBM Research in the year of 1970. The mode

Which is a legal expression in SQL? SELECT NAME FROM EMPLOYEE is a legal expression in SQL.

let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation

Assume that you are responsible for selecting a new DBMS product for Sohar Hospital

What is Relational Algebra? Relational algebra is a Procedural query Language?

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

Express the subsequent query in SQL assumes which the data is stored within EMPLOYEE table with relevant fields (i) Display name, job, salary, and hire date of employee who are

Q. Describe how an ER schema can be represented by relation schemas and constraints arising from ER design can be mapped to constraints on a relation schema.     The entity rela

Creating a view: A query can be embedded within the CREATE VIEW STATEMENT A query can have complex select statements containing join, groups and sub- queries A quer