Suppose I have a table X:
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
If I order by Salary,Name, the Name will not be grouped together. Can anyone help me with
Thank you very much!
Windows Live Photo gallery