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