INTERSECT operator Assignment Help

Assignment Help: >> SET operators - INTERSECT operator

INTERSECT operator

All the general distinct values are alone selected through the INTERSECT Operator.

 

363_INTERSECT operator.png


Example

SELECT * FROM x INTERSECT SELECT * FROM Y
This would return


ITEMCODE      NAME
    2                 Soaps

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd