Let's say i have a user table like this :
+----+-----------+---------+------------+------+
| ID | Name      | Email                | Age  |
+----+-----------+---------+------------+------+
| 1  | John      | john.doe1@mail.com   | 24   |
| 2  | Josh      | josh99@mail.com      | 29   |
| 3  | Joseph    | joseph410@mail.com   | 21   |
| 4  | George    | gge.48@mail.com      | 28   |
| 5  | Joseph    | jh.city89@mail.com   | 24   |
+----+-----------+---------+------------+------+
In the actual, it have more data but the point is i want to get the first and the second row that have name "Joseph", but how to do it ? My code this far...
User::withTrashed()->groupBy('name')->havingRaw('count("name") >= 1')->get();
With that code the result will retrieve :
| 3  | Joseph    | joseph410@mail.com   | 21   |
And i use this code to try to get the second duplicate row :
User::withTrashed()->groupBy('name')->havingRaw('count("name") >= 2')->get();
The result still same as the mentioned above :
| 3  | Joseph    | joseph410@mail.com   | 21   |
I want the result is to get record that have the id "5" with name "Joseph", can anybody give me suggestion ?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire