Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Comparisons in Relational Algebra

Re: Comparisons in Relational Algebra

From: <sriniv79_at_my-deja.com>
Date: 2000/06/18
Message-ID: <8iival$5if$1@nnrp1.deja.com>#1/1

Try:
Sigma between 1990 and 1995

In article <3934FFB1.208BCF52_at_cyberway.com.sg>,   Tan Chee Sin <cheesin_at_cyberway.com.sg> wrote:
> Let's say I want to select those tuples where the Year falls between
> 1990 and 1995. Is there a shorter way of expressing this?
>
> sigma Year >= 1990 ^ Year <= 1995 (relation)
>
> where sigma denotes the selection symbol.
>
> Thanks.
> Chee Sin
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Jun 18 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US