How to get the last of a kind in mysql?

Question

Hi there I have this in mysql.

record rate update
   1      1      1
   2      1      2
   3      1      3
   4      1      4
   5      2      1
   6      2      2
   7      3      1
   8      3      2
   9      3      3

I want to select the rows with the last update of each rate.

For example:

the last row of rate 1 is (4 1 4),     
the last row of rate 2 is (6 2 2)     
and the last row of rate 3 is (9 3 3).

Would it not be better to log a time/date stamp for each entry? — NewToJS, May 02 '18 at 05:19
Incidentally, this is the most frequently asked question under this tag — Strawberry, May 02 '18 at 06:28
Yes. It inserts a new record every time a user updates any rate. — Israel, May 02 '18 at 06:28

score 1 · Accepted Answer · answered May 02 '18 at 05:11

1

select max(record), rate, max(update)
from your_table
group by rate

answered May 02 '18 at 05:11

juergen d

201,996
37
293
362

How to get the last of a kind in mysql?

1 Answers1