0

I need to get the most recently updated distinct records of people.

ID           Name           Balance         Last Update
-------      -------        -------         -------
1            John           2500            2020-09-10
2            Ali            3900            2020-09-12
3            Steve          2000            2020-09-17
4            Ali            4500            2020-09-17

I need to get a list of unique Names with their most recently updated balance.

I am using Laravel and have tried the following:

DB::table('latest_balances AS s')
->orderBy('s.id', 'DESC')
->groupBy('name');

I get a list of unique names but it doesnt get the updated balance for Ali.

I need the following:

ID           Name           Balance         Last Update
-------      -------        -------         -------
1            John           2500            2020-09-10
3            Steve          2000            2020-09-17
4            Ali            4500            2020-09-17

Any help would be appreciated.

Strawberry
  • 33,750
  • 13
  • 40
  • 57
M Reza Saberi
  • 7,134
  • 9
  • 47
  • 76

0 Answers0