Re: How to write a SELECT to do ...

From: Ben Ryan <benryan_at_my-deja.com>
Date: Tue, 18 Jan 2000 20:40:25 GMT
Message-ID: <862j3l$o4b$1@nnrp1.deja.com>

In article <20000114211117.18704.00000442_at_ng-fb1.aol.com>, cdr628_at_aol.com (Cdr628) wrote:
> Are you trying to extract data or write to the table?
>
> Am I correct that all you want to do is select the three items from
the table
> -- acct_no, date, closing balance, and the number of days since the
1st of
> January (what year) have elapsed to the date in the date column?
>

Just trying to write a select statement.

Number of days the closing_balance was in effect. (During the month in question - so if the last balance was for, say, the 30th Dec. then the balance was in effect for two days, namely, the 30th and the 31st.)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Jan 18 2000 - 14:40:25 CST