按子句顺序计算两列的总和-Laravel [英] Calculate sum of two columns in order by clause - laravel

问题描述

我正在尝试将下面的mysql查询转换为laravel等效项.

I'm trying to convert the below mysql query into laravel equivalent.

select email from emails 
order by call_count + receive_count desc;

向拉拉维尔(Laravel)

to Laravel

DB::table('emails')
->select('email')
->orderBy(SUM('call_count','receive_count'), 'DESC')
->get();

请让我知道..谢谢

推荐答案

尝试一下

DB::table('emails')
    ->select('email')
    ->orderBy(DB::raw("`call_count` + `receive_count`"), 'desc')
    ->get();

这篇关于按子句顺序计算两列的总和-Laravel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！