Laravel 不同计数

2021-12-26 00:00:00 database php laravel eloquent

有什么办法可以让这个查询使用 laravel 工作吗?DB::raw 或 Eloquent 用法无关紧要.

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"}])

我只想数到 15.

推荐答案

你可以这样简单地用 count 替换 get:

you can simply replace get with count in this way:

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

还可以:

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

相关文章