Query

#1

I've 3 columns with customerID, orderDate and Quantity. How do I obtain a
list of customers with the last (maximum) orderDate and Quantity?

#2

Angela <Angela (AT) discussions (DOT) microsoft.com>'s wild thoughts
were released on Tue, 20 Nov 2007 11:52:00 -0800 bearing the
following fruit:

Quote:

I've 3 columns with customerID, orderDate and Quantity. How do I obtain a
list of customers with the last (maximum) orderDate and Quantity?

Do you want the last (maximum) entry for each customer, or
only customers with an order date that matches the last
(maximum) order date on the system?

--
Jan Hyde

https://mvp.support.microsoft.com/profile/Jan.Hyde

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Query

Dotnet FAQs microsoft.public.dotnet.faqs

Query - 11-20-2007 , 01:52 PM

Re: Query - 12-20-2007 , 07:14 AM