PHP mysql multiple row most recent result

Question

I have a mysql table that look like this

I'm trying to create a mysql request that will give me, for a specific node, the last available value of each type ( and I have the list of type in another table ).

I really have no idea if its even possible or the right approach to do this kind of task,... i'm not an expert in mysql

I'm trying to obtain a table where i'll be able to reach each last value of a specific type like 'PH' — Jean-Gabriel Maurice, Oct 29 '17 at 22:44

score 0 · Answer 1 · answered Oct 29 '17 at 19:09

0

I would be inclined to use a correlated subquery in a WHERE clause. I think you are asking for:

select d.*
from data d
where d.date = (select max(d2.date)
                from data d2
                where d2.node = d.node and d2.type = d.type
               );

answered Oct 29 '17 at 19:09

Gordon Linoff

1,242,037
58
646
786

As a note: Under many circumstances, this will have better performance than the accepted answer in the "duplicate". – Gordon Linoff Oct 29 '17 at 19:21

PHP mysql multiple row most recent result

1 Answers1