dcsimg
LinkedIn
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Beginner
Aug 9, 2018

Fetching Common Records Between Two 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
Hannes du Preez
 
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date