Nested select using laravel query builder?

Question

I'm trying to find a way convert it to query builder in laravel but I still can't do it!!

SELECT * FROM (
  SELECT thanhvientrong.manguoidung, detai.ngaykt, COUNT(*)
    AS c FROM detai
    INNER JOIN thanhvientrong ON detai.madt = thanhvientrong.madt AND detai.id_cap = 5
    GROUP BY thanhvientrong.manguoidung HAVING c > 0
  )
  AS dem where DATE(ngaykt) BETWEEN '2019-09-14' AND '2020-09-15'

score 0 · Answer 1 · edited Sep 14 '20 at 15:41

0

Firstly, I'm not really catch what you mean. But, i think these solutions will help you:

I think relationship will be the best solution for your issue.

edited Sep 14 '20 at 15:41

Dharman

30,962
25
85
135

answered Sep 14 '20 at 15:35

quachtinh761

224
1
7

Nested select using laravel query builder?

1 Answers1