Selecting latest record of a duplicate uid

Question

I want to select the last saved record of a user from a table.Sometimes each user can have a duplicate uid which is the main search criteria but each record has a different id and date-time. If i select it using this

  SELECT * from recharges WHERE uid = '$uid' LIMIT 1

it returns the first record of the user as oppose to what i want it to retrieve.

It would help to see the actual table structure. This sounds like a database design problem. — Michael Bolli, Oct 29 '18 at 10:36
It actually returns an indeterminate/arbitrary result (although in practice, this could often be the 'first'). Remember, rows in SQL have NO order other than that specified by an ORDER BY clause. — Strawberry, Oct 29 '18 at 10:40

score 0 · Accepted Answer · answered Oct 29 '18 at 10:35

0

You will need to sort the order in descending order by id (Assuming it to be your PK, where higher id value means latest entry)

SELECT * FROM recharges 
WHERE uid = '$uid' 
ORDER BY id DESC 
LIMIT 1

answered Oct 29 '18 at 10:35

Madhur Bhaiya

28,155
10
49
57

Hi, please can you show me how to update the current user record without updating the other records that share the same uid – Emmyz Oct 29 '18 at 11:37
1

@Emmyz please post a new question with some relevant sample data and expected output. – Madhur Bhaiya Oct 29 '18 at 11:38
@Emmyz do consider upvoting this answer as well . Thanks :) – Madhur Bhaiya Oct 29 '18 at 11:38

Selecting latest record of a duplicate uid

1 Answers1