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'

Dharman · Accepted Answer · 2020-09-14 15:41:26Z

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, 2020 at 15:41

Dharman♦

34k27 gold badges106 silver badges158 bronze badges

answered Sep 14, 2020 at 15:35

quachtinh761

2341 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Nested select using laravel query builder?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related