/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

14 votes133 views2 answers
Ucfirst
PHP
15 votes188 views3 answers
Pass data to blade laravel
PHP
0 vote118 views1 answer
Cron job every 5 minutes wordpress
PHP Wordpress
0 vote120 views1 answer
Php static dropdown list example
PHP
0 vote115 views1 answer
Php pdf
PHP
3 votes138 views1 answer
Check file size validation laravel
PHP Laravel
0 vote125 views1 answer
Meta_value wordpress
PHP
6 votes139 views3 answers
Disable foreign key laravel
PHP Laravel
1 vote215 views2 answers
Laravel form
PHP Laravel
0 vote134 views1 answer
Install pusher package in laravel
PHP Laravel