Re: sql statement

From: <tandym_at_hotmail.com>
Date: Wed, 27 Sep 2000 16:05:09 GMT
Message-ID: <8qt5re$3ma$1_at_nnrp1.deja.com>


select count(id) from my_table
where id = 12345
and date >= date - 365;

sonya

> the date field, that from the current date, are less than a year old.
>
> Thanks.
>
> Steve
>
> Newsgroup replies preferred. Remove nospam when replying thru email.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Sep 27 2000 - 18:05:09 CEST

Original text of this message