count rows but not with the same id

Question

I have this table patients

patient_id | job

  2          nurse
  2          carpenter
  1          programmer

It should count 2 because it didnt include the same id

does anyone know a query for that? I'm using laravel

and this is my code so far

App\Notification::select('patients.*',DB::raw('count(*) as total'))

Possible duplicate of [distinct count(\*)](http://stackoverflow.com/questions/4887214/distinct-count) — Saa, Feb 21 '17 at 18:44
Duplicate : http://stackoverflow.com/questions/28651727/laravel-eloquent-distinct-and-count-not-working-properly-together — Naveed Ramzan, Feb 21 '17 at 19:02

score 1 · Answer 1 · answered Feb 21 '17 at 22:25

1

App\Notification::distinct('patient_id')->count();

answered Feb 21 '17 at 22:25

Neabfi

score 0 · Answer 2 · answered Feb 21 '17 at 18:46

0

try

SELECT COUNT(DISTINCT patient_id) FROM table_name;

that should work ... sorry ... had them backwards before

answered Feb 21 '17 at 18:46

Andrew Ferguson

score 0 · Answer 3 · answered Feb 21 '17 at 20:33

0

Using Eloquent, you can do something like this:

$noti = \App\Notification::groupBy('patient_id')->get();
$count = $noti->count();

answered Feb 21 '17 at 20:33

geckob

3 Answers3