Ordering using Max?

  • Thread starter Thread starter Mike
  • Start date Start date
M

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
 
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?
 
Back
Top