How to select latest record with same unique foreign id?

Question

Hi i want to select the record with latest updated status using task_id as foreign key, I want this in Phpfox based query, but if can solve let me know the general query for this scnario

id     task_id   status
--------------------------
 1       2           1
 2       3           3
 3       2           3
 4       2           2  <------- select this record
 5       4           1

What do you mean by "last updated"? Is there a timestamp somewhere? — shmosel, Feb 21 '17 at 08:41
there is no time_stamp column in row i want record with task_id = 2, it's clear see the example table in question — Mudassar Zahid, Feb 21 '17 at 08:43
if i add a column time_stamp then what will be scenario to fetch data in same situation — Mudassar Zahid, Feb 21 '17 at 08:50

score 1 · Accepted Answer · answered Feb 21 '17 at 08:46

1

Is this what you want? task_id = 2 with last updated status(or I can say last inserted in table):

SELECT * FROM tbl_name WHERE task_id = 2 ORDER BY id DESC LIMIT 1

answered Feb 21 '17 at 08:46

B. Desai

16,414
5
26
47

How to select latest record with same unique foreign id?

1 Answers1