Help with sorting please

[ecoleman]

Hi,

 

I need to sort a query by two columns, but only use the second column value if the first column is equal to 0.

 

eg.

 

Name  | Primary Order | Secondary Order

Fred    | 1                    | 10

Sue      | 0                    | 2

William | 10                | 3

Richard | 0                  | 1

 

would ideally be sorted as (Primary Order or Secondary (If Score = 0)), name

which should produce a result like

 

Fred - (1)

Richard - (1)

Sue - (2)

William - (10)

 

Any help would be greatly appreciated.

Thanks in advance.

[Illusion]

CASE statement is what you need.

[ecoleman]

Superb,

 

I ended up with

 

SELECT name from table ORDER BY CASE WHEN primary_order != '0' THEN primary_order ELSE secondary_order END

 

and that works a treat.

Thank You.

[fenway]

I would have flipped that around, but yes.

[ecoleman]

I did actually flip it around in the end