sql statement
From: Steve . <syarbrou_at_nospam.enteract.com>
Date: Wed, 27 Sep 2000 10:22:48 -0500
Message-ID: <qn34ts8nmhtuaq2tgh4o1dsqb4t93ss4pt_at_4ax.com>
Date: Wed, 27 Sep 2000 10:22:48 -0500
Message-ID: <qn34ts8nmhtuaq2tgh4o1dsqb4t93ss4pt_at_4ax.com>
[Quoted] I'm trying to figure out an SQL statement to do the following.
Enter a number: 12345
use that number against a table with the following values:
id, date
The id is not unique. So when the number 12345 is entered I want to count the number of entries with 12345 for the id, that have dates in [Quoted] 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. Received on Wed Sep 27 2000 - 17:22:48 CEST