Ordering using Max?

[Mike]

Hi,

In a query I've

Count(sold) as yr_total

Salesman_ID

Sum(cost) as in_total

Month(date_sale) as Cmonth

Where Year(date_sale) as Cyear = 2005

Order by Salesman_ID



I'd like to order the query by Salesman_ID who has sold the most in the year
to the one who has sold the less. Howto do it?

TIA

Mike

 

[Mike]

Hooops!!

I'd like to order the query by Salesman_ID who has sold the most in the year
to the one who has sold the less and ordering them by month. Howto do it?