What is the correct way to use distinct in such a query?

Question

Laravel

Laravel version: 5.5.*
I use this method to get 50 rows from the database.

/**
     * Display the specified resource.
     *
     * @param  int  $id
     * @return \Illuminate\Http\Response
     */
    public function show($id)
    {
      $prices = Prices::where('name',$id)->take(50)->get();
      return GraphResource::collection($prices);
    }

But according to the last_updated field, I need to get records with a non-repeating key value (the column stores the time in timestamp format).
I'm trying to do this:

$prices = Prices::where('name',$id)->take(50)->distinct('last_updated')->get();

But the data is still displayed with duplicate last_updated values.
How to select from a database of 50 values ​​with unique data in last_updated?

Answer 1

id: 1, last_updated: 1524855575, price: 5000
id: 2, last_updated: 1524855575, price:5000.

You can group through groupBy('name', 'last_updated') then there will be unique results.
You should also think about adding a unique last_updated/name key so that such records are not entered into the database.