Level 102
You are still getting the first row I think
can you try
SELECT MAX(`checkid`) AS cid, transdate, transdescribe, widthdraw, deposit, isclr FROM checks WHERE isclr = 1 ORDER BY checkid DESC
Mar 21, 2022
7
Level 75
Anyone else having wrong results from MySql MAX
With this data:
If I run:
SELECT MIN(`checkid`) AS cid, transdate, transdescribe, widthdraw, deposit, isclr FROM checks WHERE isclr = 0
MIN gives me the entire correct row:
However using MAX:
SELECT MAX(`checkid`) AS cid, transdate, transdescribe, widthdraw, deposit, isclr FROM checks WHERE isclr = 1
Gives correct checkid, but other fields are wrong, it gives max amount instead.
Level 75
@Sinnbeck same result, the MIN gives correct row. Max gives correct checkid, but other data is from max amount row, see images.
Level 104
This is a greatest-n-per-group problem; it is coincidental that the MIN record is correct.
1 like
Level 39
Level 75
@sr57 I am only after the date that goes with that row anyway, eventually the queries will be converted in laravel where parameters are used, so I will just use 2 queries, one to get max, and from the checkid another to get date for the row.
Level 102
@jlrdw order by with limit of 1 is probably better then :)
Level 75
@Sinnbeck I rewrote it using:
SELECT
*
FROM
checks
WHERE isclr = 1
ORDER BY checkid DESC
LIMIT 1;
And works great. Got idea from https://www.mysqltutorial.org/mysql-max-function/
Thanks for all answers, I should have known better, but I don't work with max often, usually sum and count.
Please or to participate in this conversation.