dcsimg
 

Submitted by: Hannes du Preez(ojdupreez1978@gmail.com)

Thursday Aug 9th 2018 by Hannes du Preez

Language: SQL, Expertise: Beginner - See how to fetch records that are common to one or more tables.

You can fetch records that are common to one or more tables by using INTERSECT. Here is a small example:

Select * from Employees

Intersect

Select * from RetiredEmployees
Home
Mobile Site | Full Site