如何编写Laravel orderBy查询? [英] How to write Laravel orderBy query?

问题描述

我在laravel中尝试过，但是没有用.

i tried this in laravel,but its not worked.

$doctor_daily=ReportDoctorCompanyDailyTestModal::select('test_id',DB::raw('SUM(test_price) as num'))
                                                       ->join('testing_types','report_doctor_company_daily_test.test_id','=','testing_types.id')
                                                       ->join('doctor','doctor.id','=','report_doctor_company_daily_test.doctor_id')
                                                       ->groupBy('test_id')
                                                       ->get();

如何在Laravel 5.7中编写此MySQL查询?

How to write this MySQL query in Laravel 5.7?

SELECT
    report_doctor_company_daily_test.test_id,
    testing_types.testing_name,
    doctor.first_name,
    doctor.last_name,
    SUM( report_doctor_company_daily_test.test_price ) 
FROM
    testing_types
    INNER JOIN report_doctor_company_daily_test ON testing_types.id = report_doctor_company_daily_test.test_id
    INNER JOIN doctor ON report_doctor_company_daily_test.doctor_id = doctor.id 
GROUP BY
    testing_types.id

推荐答案

使用可以使用->orderBy();语句.

例如；

$doctor_daily=ReportDoctorCompanyDailyTestModal()->orderBy()->get();

然后您可以通过升序获取数据.如果要降序，可以使用

Then you can get data by ascending order. if you want descending order, can use

->orderBy('id','DESC');

这篇关于如何编写Laravel orderBy查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！