Re: sql statement

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 - 11:05:09 CDT