showing first/last instance and largest instance

[sap1958]

select giftid
max(giftamount)as Largest Gift,
max(giftdate) as most recent date,
min(giftamount)as Smallest Gift,
min(giftdate) as first date

I am trying to find the following
largest gift amount
Date of Largest gift amount
First gift amount
Date of First gift amount

Last gift amount
Date of Last Gift amount

Last 10 gift gifts
Date of Last 10 gifts

will I need to do a row() function?

 

[bborissov]

I think you should post your question here:
thread183-1608562

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[bborissov]

Sorry, I thought I copied the forum link.
Here the right link:
forum183

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.