/PHP/How to use union and intersection in laravel query

How to use union and intersection in laravel query

$queryWithParent = SaleService::query()
    ->select(\DB::raw('DISTINCT ON (properties.parent_id) sale_services.*'))
    ->from('sale_services')
    ->join('properties', 'sale_services.property_id', '=', 'properties.id')
    ->whereNotNull('properties.parent_id')
    ->orderBy('properties.parent_id')
    ->orderBy('sale_services.index_range', 'desc');

$queryWithoutParent = SaleService::query()
    ->select(\DB::raw('sale_services.*'))
    ->join('properties', 'sale_services.property_id', '=', 'properties.id')
    ->whereNull('properties.parent_id');

$query = $queryWithParent->union($queryWithoutParent);

Source: stackoverflow.com

Similar codes

3 votes228 views2 answers
Laravel db exists
PHP Laravel
0 vote226 views2 answers
Socket io laravel
PHP Laravel
2 votes207 views1 answer
Call model function in controller laravel
PHP
0 vote239 views1 answer
Laravel vue browser cache auto clear
PHP Laravel
0 vote229 views1 answer
First-class Callable Syntax - PHP 8.1
PHP
0 vote231 views1 answer
View-source.https//moodle.alaqsa.edu.ps/mod/quiz/review.php
PHP
10 votes241 views3 answers
Session flush laravel
PHP
1 vote253 views2 answers
Laravel add attribute to model
PHP Laravel
21 votes240 views3 answers
Php get parameter
PHP
0 vote223 views6 answers
Php email
PHP