I do not know how to select rows that agent_key is unique. I used groupBy and distinct to do this, but I did not succeed.
This is my table:
Asked
Active
Viewed 46 times
0
John Conde
- 217,595
- 99
- 455
- 496
Mohsen Gorzin
- 186
- 1
- 10
-
1How did you use `groupBy` and `distinct` ? Maybe share your code? – user3532758 Jul 20 '21 at 10:00
-
$query = distinct()->select('agent_key'); – Mohsen Gorzin Jul 20 '21 at 10:12
-
https://stackoverflow.com/a/25228908/3532758 – user3532758 Jul 20 '21 at 10:16
-
This link (stackoverflow.com/a/25228908/3532758) didn't return complete row. – Mohsen Gorzin Jul 20 '21 at 10:23
-
try ModelName::groupBy('agent_key ')->havingRaw('count(agent_key )=1')->get(); – John Lobo Jul 20 '21 at 10:23
1 Answers
0
YourModal::get()->unique('agent_key');
Moolchand Sharma
- 198
- 1
- 3
-
I can't use unique Call to undefined method Illuminate\Database\Eloquent\Builder::unique() – Mohsen Gorzin Jul 20 '21 at 10:15
-
-
-
$query = DB::table('agents')-> distinct()->select('agent_key')->get(); Or $query = DB::table('agents')-> distinct('agent_key)->get(); – Mohsen Gorzin Jul 20 '21 at 11:00
-
When I try to use "SELECT DISTINCT `agent_key` FROM `agents`" this query doesn't return completed row – Mohsen Gorzin Jul 20 '21 at 11:07
-