/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

37 votes173 views6 answers
Laravel order by
PHP Laravel
3 votes162 views1 answer
Laravel check if array is empty
PHP Laravel
31 votes151 views3 answers
Carbon laravel use
PHP Laravel
0 vote154 views1 answer
Laravel display old value in form
PHP Laravel
2 votes153 views1 answer
Redirect on validation error laravel to specific section laravel
PHP Laravel
4 votes173 views1 answer
Laravel install production
PHP Laravel
-1 vote161 views2 answers
Fresh migrqte laravel
PHP Laravel
2 votes156 views1 answer
Laravel sluggable
PHP Laravel
9 votes147 views3 answers
Make controller laravel 8 with resource
PHP Laravel
11 votes160 views3 answers
Laravel auth 6
PHP Laravel