/PHP/Laravel/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

1 vote193 views1 answer
Laravel multiple orderby
PHP Laravel
1 vote194 views2 answers
Laravel required_with
PHP Laravel
0 vote197 views1 answer
Url() inside laravel config files
PHP Laravel
2 votes164 views2 answers
Importing current year in laravel blade
PHP Laravel
17 votes163 views6 answers
Laravel Routing
PHP Laravel
9 votes192 views3 answers
Laravel join 2 tables eloquent
PHP Laravel
4 votes188 views1 answer
How to check query execution time in laravel
PHP Laravel
22 votes201 views5 answers
Get logged user id laravel
PHP Laravel
1 vote173 views1 answer
Laravel validate enum field
PHP Laravel
6 votes189 views4 answers
Unique check with multiple columns laravel validation
PHP Laravel