devxlogo

Fetching Common Records Between Two Tables

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 EmployeesIntersectSelect * from RetiredEmployees

devx-admin

Share the Post: