How to write query sql on laravel

Question

I'm new to Laravel 4. I have Query Sql Like this

SELECT at.test_id, MAX(at.result), COUNT(status_assessment_id='2') FROM recruitment_process a LEFT JOIN recruitment_result at ON a.id = at.recruitment_id GROUP BY test_id

I do not know how can I write this on Laravel 4?

Are you using Laravel 4.2?

ARIF MAHMUD RANA
– ARIF MAHMUD RANA

2015-12-27 06:20:42 +00:00
Commented Dec 27, 2015 at 6:20 — ARIF MAHMUD RANA
– ARIF MAHMUD RANA, Commented Dec 27, 2015 at 6:20
hy ARIF MAHMUD RANA yes I'm using laravel 4.2

b4dQuetions
– b4dQuetions

2015-12-27 06:23:16 +00:00
Commented Dec 27, 2015 at 6:23 — b4dQuetions
– b4dQuetions, Commented Dec 27, 2015 at 6:23

ARIF MAHMUD RANA · Accepted Answer · 2015-12-27 06:32:15Z

2

I haven't checked but you can try this

DB::table('recruitment_process a')
    ->select('at.test_id', DB::raw('MAX(at.result)'), DB::raw('COUNT(status_assessment_id="2")'))
    ->leftJoin('recruitment_result at', 'a.id', '=', 'at.recruitment_id')
    ->groupBy('at.test_id')
    ->get();

More details here https://laravel.com/docs/4.2/queries

answered Dec 27, 2015 at 6:32

ARIF MAHMUD RANA

5,2063 gold badges39 silver badges58 bronze badges

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

Comments

Matt · Accepted Answer · 2015-12-27 06:23:10Z

0

The way I would do it would be:

DB::table('recruitment_process')
    ->select(
    array('recruitment_result.test_id', 
           DB::raw('COUNT(status_assessment_id='2') as mycount'), 
           DB::raw('MAX(recruitment_result.result) as maxvalue')))
    ->left_join('recruitment_result', 'recruitment_process.id', '=', 'recruitment_result.recruitment_id')
    ->group_by('test_id')
    ->get();

Not sure if there is any faster or more effective way.

answered Dec 27, 2015 at 6:23

Matt

2,8441 gold badge15 silver badges27 bronze badges

1 Comment

b4dQuetions Over a year ago

matt yah meybe it's not effective way. but I'm appreciate you have answer I will try

Collectives™ on Stack Overflow

How to write query sql on laravel

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related