Sorry, it looked OK on my side, but I suppose some of the Excel formatting got through and messed things up.
Simplified it will be: field1 field2 field 3 ------------------------------------------- 0 47 0 0 0 0 0 0 0 and do: order by field3 desc, field2 asc Trying to get the row with 47 at the bottom. RBS On Mon, Feb 16, 2015 at 2:58 AM, Igor Tandetnik <igor at tandetnik.org> wrote: > On 2/15/2015 6:54 PM, Bart Smissaert wrote: > >> Result is shown below. >> >> *Drug**Sensitive* >> *Resistant**Ratio*Ertapenem 10201Meropenem301Pip/Tazobactam301 >> Cefalexin/Cefdrxl4070.85Gentamicin310.75CiprofloxacinS1570. >> 68Amoxicillin2115 >> 0.58Ampicillin760.54Trimethoprim18290.38Amoxyclavulanate6130.32 >> Nitrofurantoin0470Cefixime000Erythromycin000Fluclox(Met/Ox) >> 000Penicillin000 >> Tetracycline00 >> > > This is illegible. > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
