/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

2 votes141 views1 answer
Laravel vendor:publish not working
PHP Laravel
2 votes145 views2 answers
Laravel/ui for laravel 7
PHP Laravel
13 votes155 views3 answers
How to change existing migration laravel
PHP Laravel
25 votes150 views4 answers
ERROR 1071 (42000) at line 76: Specified key was too long; max key length is 767 bytes laravel
PHP Laravel
0 vote145 views1 answer
Refresh web route laravel
PHP Laravel
0 vote161 views1 answer
Laravel Add regx on password
PHP Laravel
10 votes144 views2 answers
Laravel success message
PHP Laravel
0 vote200 views1 answer
Howto+add+header+bar+laravel+app
PHP Laravel
5 votes165 views1 answer
Laravel get random row
PHP Laravel
0 vote171 views1 answer
Laravel file permission denied
PHP Laravel