Re: Tricky query

From: James Williams <willjamu_at_mindspring.com>
Date: Wed, 30 May 2001 10:10:15 GMT
Message-ID: <3b14c63b.6060566@nntp.mindspring.com>

On 30 May 2001 06:19:47 GMT, "wayne" <no_at_email.please.com> wrote: dte mm-dd-yy
tme hhmmss

Oracle 8.1.6.3 on the Sun Solaris hardware platform.

>> The DTE and TME (Don't ask why the developers didn't use DATE)
>> will be used to determine the age. The ky_premise_no can be duplicates.

The tricky part (to me!) is coming up with the three oldest ky_premise_no for each premise. Each order can can go against several premises. My charge is to return in a result the three oldest each time ordered by completion date.
>
Received on Wed May 30 2001 - 05:10:15 CDT