/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

8 votes109 views3 answers
Storage link laravel
PHP Laravel
0 vote161 views1 answer
Laravel where 2 column
PHP Laravel
2 votes113 views3 answers
Laravel where created_at today
PHP Laravel
0 vote135 views1 answer
Excel return integer from date column laravel
PHP Laravel
0 vote105 views1 answer
Text or description laravel database column type
PHP Laravel
0 vote69 views2 answers
How to structure database in laravel
PHP Laravel
10 votes129 views2 answers
Laravel array to string conversion
PHP Laravel
0 vote130 views1 answer
Laravel add model to one to many relationship
PHP Laravel
2 votes159 views3 answers
Laravel get query result as array
PHP Laravel
4 votes319 views6 answers
Laravel jwt
PHP Laravel