Laravel Distinct Count

Question

Any way to make this query work using laravel? DB::raw or Eloquent usage doesn't matter.

SELECT count(DISTINCT name) FROM tablename;

Here's what i've tried but cannot get the proper output:

EloquentTableName::select(DB::raw('count(DISTINCT name) as name_count'))->get();

This returns something like this and i'd like to fix that:

([{"name_count":"15"}])

I just want to get count 15.

can you clarify the difference between current output and expected output? — Gouda Elalfy, Mar 08 '16 at 13:22
@GoudaElalfy i just need to get the int value. I need 15. What i've got is "name_count":"15" — saimcan, Mar 08 '16 at 13:23
What if you do `->only("name_count")` instead of `->get()` ? — apokryfos, Mar 08 '16 at 13:32

Gouda Elalfy · Accepted Answer · 2016-03-08T13:33:34.650

91

you can simply replace get with count in this way:

$count = DB::table('tablename')->count(DB::raw('DISTINCT name'));

also can do:

DB::table('tablename')->distinct('name')->count('name');

edited Mar 08 '16 at 13:33

answered Mar 08 '16 at 13:28

Gouda Elalfy

score 12 · Answer 2 · edited May 08 '20 at 10:23

12

DB::table('tablename')->distinct()->count('name');

is the correct answer.

~~->distinct('name')~~ does not work in Laravel.

edited May 08 '20 at 10:23

m02ph3u5

answered May 08 '20 at 09:12

Chandan Mistry

score 7 · Answer 3 · answered Feb 18 '20 at 06:24

7

You may simply do the following:

Tablename::distinct()->count('name');

answered Feb 18 '20 at 06:24

Alisha Lamichhane

score 4 · Answer 4 · edited Jan 28 '21 at 07:16

4

you can do this as smoothly as honey

Modal::('yourTable')->distinct()->count('yourAttribute')

and it will fetch unique count number of 'yourAttribute'.

edited Jan 28 '21 at 07:16

saimcan

answered Jan 27 '21 at 09:08

M Behlole Aqil

4 Answers4