Hi netters,
Suppose I have a table X:
Name Salary
Tom 1000
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 table would
be:
Tom 4000
Tom 1000
Mike 3500
Mike 2000
Jack 3000
If I order by Salary,Name, the Name will not be grouped together. Can anyone help me with
this?
Thank you very much!
Zhihua Li
_________________________________________________________________
Windows Live Photo gallery
数码相机的超级伴侣，轻松管理和编辑照片，还能制作全景美图！
http://get.live.cn/product/photo.html
