orm 实现子查询

最新推荐文章于 2023-06-26 12:43:12 发布

原创最新推荐文章于 2023-06-26 12:43:12 发布 · 808 阅读

0 ·

CC 4.0 BY-SA版权

Laravel 专栏收录该内容

1 篇文章

订阅专栏

SELECT COUNT(*) FROM (SELECT * FROM abc WHERE col1 = xxx and col2 = xxx GROUP BY col1) AS sub WHERE col1 = xxx and col2 = xxx and col3 = xxx;

use Illuminate\Support\Facades\DB; 
$subQuery = DB::table('abc')->where('col1', 'xxx')->where('col2', xxx)->groupBy('col1); 
$query = DB::table(DB::raw("({$subQuery->toSql()}) as sub")) ->select(DB::raw('count(*)')) ->where('col1', 'xxx') ->where('col2', 'xxx') ->where('col3', 'xxx'); 
// 合并绑定参数
 $query->mergeBindings($subQuery); 
OR 
$query->mergeBindings($subQuery->getQuery()); 
$query->get();