Skip to Content
0
Former Member
Sep 25, 2005 at 10:18 PM

How to get the max value in the query??

24 Views

Plant calday(mm.dd.yyyy) Soldout.Qty

0001 01.01.2005 10

0001 01.02.2005 20

0001 01.03.2005 05

0001 01.04.2005 16

0001 01.05.2005 10

0001 01.06.2005 14

From the above values , how can i findout Max(Soldout.Qty)(i.e 20) for the above week...Suppose present aggregation = summation...How can i findout the value in the Query??don't want to do changes to design...