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.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users