Interview Questions - SQL SERVER- what are EXCEPT and INTERSECT?

Getting Started with Adobe After Effects - Part 6: Motion Blur

This module helps you to share, discuss and learn interview questions and answers of different technologies

Home · Most Liked · Most Asked · Most Discussed · Sections

SQL SERVER- what are EXCEPT and INTERSECT?

May 28 2012 12:00AM by Nirav Gandhi

In SQL SERVER, what are EXCEPT and INTERSECT?

Both Returns distinct values by comparing the results of two queries.

EXCEPT returns any distinct values from the left query that are not also found on the right query.

INTERSECT returns any distinct values that are returned by both the query on the left and right sides of the INTERSECT operand.

Read More.. [148 clicks]

Nirav Gandhi

38 · 5% · 1503

Liked

Asked


Post this to my facebook wall
Tweet this
Like this
I have asked or faced this question during an interview

Your Comment

Sign Up or Login to post a comment.