T-SQL : Intersect, Except, Union, All and Any

  • Article

A good article on some SQL basics :

I was reviewing the Microsoft training courses for SQL2008 for a set of application developers who wanted to learn more about SQL Server. In doing so I came across some commands that I either had not heard of or had not used before.

  • INTERSECT
  • EXCEPT
  • ALL
  • ANY

image

The full article is here : https://www.sqlservercentral.com/articles/T-SQL/67545/ _us