[sort order]how to support sort by max(field1),then field2 desc.

[Jack Liu]

As we know, the we can sort by multi-fields, such as field1 , then field2.

But I have another scenario:
We need pick up the max(field1) record first, then sort by field2 for others 
records.

Anyone can help me?

Thanks in advance.


Thanks
Jack