Dear Igor, -------------------------------------------- From: Igor Tandetnik <[email protected]> Sent: Mon, 22 Sep 2014 15:25:43 -0400 To: [email protected] 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: [email protected] xmpp: [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
