How to sort values from lowest to highest, but leaving the zeroes last:
SELECT foo FROM bar order by foo = 0, foo ASC
CNN.com- Philippines issues local tsunami alert
- 'I'm sorry. Goodbye' precedes fatal Washington explosion
- Australians urged to flee flooding
- More caucuses next stop for Romney
- Activist: Rockets rip through Syrian city
- Sex abuse cases close school for days
- Lacrosse player faces trial in ex's death
- Saudi woman sues over right to drive
- Gingrich's Southern revival strategy
- Opinion: Syria in for bloody stalemate
- BBC
- Police chief at Leveson Inquiry
- Many trapped in Lahore collapse
- Romanian PM resigns over protests
- Web firms remove India material
- Syria troops step up Homs bombing
- Accidents due to icy conditions
- MP's call to fight web extremists
- Bank lending 'to shrink' in 2012
- Capello opposes FA Terry decision
- Woman runs for Mexico presidency
- AL JAZEERA ENGLISH (AJE)
- Suu Kyi given go-ahead to run in by-election
- Romania's PM resigns over austerity protests
- Abbas 'proposed as PM' in unity government
- US seeks 'clarification' over Egypt NGO trial
- Scores trapped in Pakistan building collapse
- Syrian army 'steps up Homs offensive'
- Obama 'in lockstep' with Israel on Iran issue
- Mexico's ruling party picks female candidate
- Noriega hospitalised over suspected stroke
- New York Giants win Super Bowl title