/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

0 vote162 views1 answer
Send image in request body laravel 6
PHP Laravel
0 vote299 views1 answer
Touches in laravel
PHP Laravel
6 votes200 views4 answers
Insert data using seeder in laravel
PHP Laravel
0 vote174 views2 answers
Laravel allow all fillable
PHP Laravel
0 vote188 views1 answer
Laravel migration unknown column type double requested
PHP Laravel
16 votes247 views4 answers
Laravel auth helper function
PHP Laravel
15 votes175 views3 answers
How to install bootstrap in laravel 8 with auth
PHP Laravel
0 vote204 views1 answer
Laravelda so`rovlarni cheklash
PHP Laravel
1 vote184 views1 answer
Groupby in laravel with count
PHP Laravel
2 votes183 views5 answers
Laravel drop table migration
PHP Laravel