Scott Selikoff wrote:What exactly is the problem? There's no such ordering as "as they are in the database". When you don't specify ordering on a column, like country, the database is free to return it however it wants, and inconsistently between queries. If ordering matters, then you should order the columns.
For example,
type country
----------- --------------
Currency United States
Bond Future Japan
Bank Debt United States
Bond Future United States
Bond Future United States
Bond Future New Zealand
Bond Future Canada
Bond Future United States
Currency Japan
returns
type country
----------- --------------
Currency United States
Currency Japan
Bond Future Japan
Bond Future United States
Bond Future United States
Bond Future New Zealand
Bond Future Canada
Bond Future United States
Bank Debt United States
I just want to sort by type now. That is all.
type country
----------- --------------
Bank Debt United States
Bond Future Japan
Bond Future United States
Bond Future United States
Bond Future New Zealand
Bond Future Canada
Bond Future United States
Currency United States
Currency Japan
In the group for Currency I want United States to be first. And I don't want country to by sorted (neither ASC nor DESC).