Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Laravel Eloquent group by most recent record
Language:
Ada
Assembly
Bash
C#
C++ (gcc)
C++ (clang)
C++ (vc++)
C (gcc)
C (clang)
C (vc)
Client Side
Clojure
Common Lisp
D
Elixir
Erlang
F#
Fortran
Go
Haskell
Java
Javascript
Kotlin
Lua
MySql
Node.js
Ocaml
Octave
Objective-C
Oracle
Pascal
Perl
Php
PostgreSQL
Prolog
Python
Python 3
R
Rust
Ruby
Scala
Scheme
Sql Server
Swift
Tcl
Visual Basic
Layout:
Vertical
Horizontal
DROP TABLE IF EXISTS yourTable ; CREATE TABLE yourTable (`ID` int, `Customer` varchar(7), `City` varchar(5), `Amount` int) ; INSERT INTO yourTable (`ID`, `Customer`, `City`, `Amount`) VALUES (1, 'Cust001', 'City1', 2), (2, 'Cust001', 'City2', 3), (3, 'Cust001', 'City1', 1), (4, 'Cust001', 'City2', 1), (5, 'Cust001', 'City2', 3), (6, 'Cust001', 'City3', 1), (7, 'Cust001', 'City3', 1), (8, 'Cust002', 'City1', 2), (9, 'Cust002', 'City1', 1), (10, 'Cust002', 'City2', 3), (11, 'Cust002', 'City1', 2), (12, 'Cust002', 'City2', 1), (13, 'Cust002', 'City3', 2), (14, 'Cust002', 'City3', 3), (15, 'Cust003', 'City1', 1), (16, 'Cust003', 'City2', 3), (17, 'Cust003', 'City3', 2) ; select t.* from yourTable t join ( select Customer,City,max(ID) ID from yourTable group by Customer,City ) t1 on t.Customer = t1.Customer and t.City = t1.City and t.ID = t1.ID
absolute service time: 0,37 sec
edit mode
|
history
ID
Customer
City
Amount
1
3
Cust001
City1
1
2
5
Cust001
City2
3
3
7
Cust001
City3
1
4
11
Cust002
City1
2
5
12
Cust002
City2
1
6
14
Cust002
City3
3
7
15
Cust003
City1
1
8
16
Cust003
City2
3
9
17
Cust003
City3
2