Laravel Eloquent select all rows with max created_at

by

To get latest record for each seller_id you can use following query

select s.*
from snapshot s
left join snapshot s1 on s.seller_id = s1.seller_id
and s.created_at < s1.created_at
where s1.seller_id is null

Using query builder you might rewrite it as 

DB::table('snapshot as s')
  ->select('s.*')
  ->leftJoin('snapshot as s1', function ($join) {
        $join->on('s.seller_id', '=', 's1.seller_id')
             ->whereRaw(DB::raw('s.created_at < s1.created_at'));
   })
  ->whereNull('s1.seller_id')
  ->get();

More Related Contents:

  1. How do I store a custom user selected CSS template style (like wordpress visual editor)? [closed]
  2. Laravel – only a zero is saved to the database
  3. PDOException SQLSTATE[HY000] [2002] No such file or directory
  4. How to do this in Laravel, subquery where in
  5. Laravel migration: unique key is too long, even if specified
  6. Laravel: PDOException: could not find driver
  7. Doctrine Query Language get Max/Latest Row Per Group
  8. Laravel: connect to databases dynamically
  9. Laravel eager loading with limit
  10. How to join three table by laravel eloquent model
  11. Laravel OrderBy relationship count
  12. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  13. SQLSTATE[HY000] [2002] A connection attempt failed.. – When attempting to connect from Local to remote server
  14. Setting up Laravel on a Mac php artisan migrate error: No such file or directory [duplicate]
  15. Laravel 5.4 field doesn’t have a default value
  16. “No such file or directory” or “No such host is known” when running migrations
  17. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  18. Laravel nested relationships
  19. getting the value of an extra pivot table column laravel
  20. Laravel Eloquent get results grouped by days
  21. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  22. Change name of Laravel’s created_at and updated_at
  23. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known
  24. How do I get database column names in Laravel?
  25. Laravel SQLSTATE[HY000] [2002] Connection refused
  26. Eloquent many-to-many-to-many – how to load distant relation easily
  27. Mysql InnoDB engine in Laravel
  28. Create a Insert… Select statement in Laravel
  29. How to create a database-driven multi-level navigation menu using Laravel
  30. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3

Leave a Comment