Laravel Eloquent: How to form "2 Select database" to peform count?

Question

I will ask you. in sql i have a code like this ?

    SELECT keterangan_warga, COUNT(keterangan_warga) as cnt 
    FROM ( SELECT distinct nokk_warga, keterangan_warga FROM `warga` ) as t
    GROUP by keterangan_warga;

then , i will perform this to Laravels. How can I do? Thanks, I try to 2 select but it error.

i will perform this data t laravels like this and I try to implement in laravels there is error intelephense in the second select and second from

$data = DB::selectRaw('keterangan_warga , count(keterangan_warga ) as JumlahWarga')
    ->from( select('nokk_warga', 'keterangan_warga')->distinct()->from('warga'))
    ->groupby('keterangan_warga')
    ->get();

The table name is warga, and this is the table. enter image description here

I will count keterangan_warga based on nokk_warga, i already successfully show the data that I need in sql but I dont know how to perform it in laravales. Do you have any suggestion?

@MohamedGamalEldin the question is update, do you have any idea to perform this? — Shabrina Nurdiani S, Sep 21 '21 at 04:24
Step by step, What is the name of the table? As I know you should add `table('table_name')`. — Mohamed Gamal Eldin, Sep 21 '21 at 05:01
@MohamedGamalEldin oh sory, I have an table name warga, this table contain: id (primary key) no_kk , nama_warga, and keterangan_warga. But I will count the keterangan_warga based on no_kk, no_kk is a group of some id , in sql i have a code like that and i already show the database like I need, but i will perform it to laravels, but i dont how to perform. — Shabrina Nurdiani S, Sep 21 '21 at 05:03
@MohamedGamalEldin I've updated the question and add the 'warga' table into this question, do you have any suggestion? — Shabrina Nurdiani S, Sep 21 '21 at 05:56
heelo @MohamedGamalEldin this is the error Call to undefined function App\Http\Controllers\select() , — Shabrina Nurdiani S, Sep 21 '21 at 06:20
Edit DB to this `$data = DB::table('warga')->selectRaw('keterangan_warga , count(keterangan_warga ) as JumlahWarga')->select('nokk_warga', 'keterangan_warga')->groupby('keterangan_warga')->get();` and tell me if the error changed. — Mohamed Gamal Eldin, Sep 21 '21 at 06:26
the error changed into this SQLSTATE[42000]: Syntax error or access violation: 1055 'public.warga.nokk_warga' isn't in GROUP BY (SQL: select `nokk_warga`, `keterangan_warga` from `warga` group by `keterangan_warga`) — Shabrina Nurdiani S, Sep 21 '21 at 06:34
try to see this [answer](https://stackoverflow.com/questions/40917189/laravel-syntax-error-or-access-violation-1055-error) to fix the error. — Mohamed Gamal Eldin, Sep 21 '21 at 06:38
Hello @MohamedGamalEldin after I fix the error , then the error now, the alias table from count not detected, how to fix it? Undefined property: stdClass::$JumlahWarga (View: C:\xampp\htdocs\data_bantuan\resources\views\home.blade.php) — Shabrina Nurdiani S, Sep 21 '21 at 12:42

Laravel Eloquent: How to form "2 Select database" to peform count?

0 Answers0