Query help: ordering both ASC and DESC 1

[jimoblak]

I'm stumped... What would be the SQL to order column 'a' as ASC but then column 'b' as DESC?

Example:

columns a:b

1:a
1:r
3:g
2:w
2:j
3:e
1:m

Ordered output should be as:

1:r
1:m
1:a
2:w
2:j
3:g
3:e

 

[TonyGroves]

[tt]
SELECT *
FROM tblname
ORDER BY a ASC, b DESC
[/tt]

 

[jimoblak]

Hmmm...

This is what I thought I had tried (even without the implied ASC which works as well).

I probably did something stupid earlier in the select statement. Thanks