/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

0 vote198 views1 answer
Php curl async callback
PHP
0 vote201 views1 answer
Yii::app()->request->get yii1
PHP
34 votes237 views6 answers
Php random number
PHP
0 vote236 views2 answers
Send html from datatable in laravel
PHP Laravel
0 vote278 views1 answer
Php content type xml
PHP
7 votes200 views2 answers
Prevent SQL injection in PHP?
PHP
0 vote243 views1 answer
Get post by name wordpress
PHP Wordpress
16 votes211 views2 answers
Laravel create or update eloquesnt
PHP
0 vote187 views1 answer
Php find all subclasses of class
PHP
40 votes216 views6 answers
Randomstring php
PHP