Dear Igor, -------------------------------------------- From: Igor Tandetnik <i...@tandetnik.org> Sent: Mon, 22 Sep 2014 15:25:43 -0400 To: sqlite-users@sqlite.org Subject: Re: [sqlite] sqlite max arguments assistance > > On 9/22/2014 3:12 PM, Jungle Boogie wrote: >> select * from august where transaction_amount = (select >> max(transaction_amount) from august) >> >> This statement should show be the merchant account with the top most >> expensive >> transaction from my table called august. >> >> Result: >> $999.63 > > The fact that the result is printed complete with $ sign suggests strongly > that the values are stored, and compared, as strings. '$999.63' > '$16695.36' > when using alphabetical comparison.
This is my mistake--ignore the dollar sign. I should have noted this originally. Forgive me! -- inum: 883510009027723 sip: jungleboo...@sip2sip.info xmpp: jungle-boo...@jit.si _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users