subject:"a multi\-order question"

Re: a multi-order question

2008-01-31 Thread Joerg Bruehe

Hi ! zhihuali wrote: Hi netters, Suppose I have a table X: NameSalary Tom1000 Jack 3000 Mike 1000 Mike 3500 Tom 4000 I want to do the following thing: First, order by Salary; Second, starting from the highest salary down, group

a multi-order question

2008-01-27 Thread zhihuali

Hi netters, Suppose I have a table X: NameSalary Tom1000 Jack 3000 Mike 1000 Mike 3500 Tom 4000 I want to do the following thing: First, order by Salary; Second, starting from the highest salary down, group by Name. So the resulting