Dear Simon, -------------------------------------------- From: Simon Slavin <slav...@bigfraud.org> Sent: Mon, 22 Sep 2014 20:14:08 +0100 To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Subject: Re: [sqlite] sqlite max arguments assistance > > > On 22 Sep 2014, at 8:12pm, Jungle Boogie <jungleboog...@gmail.com> wrote: > >> Result: >> $999.63 >> (I trimmed out other items that I can't show). >> >> Same results with this: select max(transaction_amount) from august >> $999.63 >> >> >> But this is NOT the most expensive amount, but it is for a three digit dollar >> amount. >> >> >> For example, this record is much higher in terms of transaction_amount: >> $16695.36 > > What is the affinity of the transaction_amount column of your august table ?
Sorry, I don't know what this means. It looks like 50 grand is the largest transaction amount, although Excel is having a hard time sorting the data well. > > Simon. -- 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
