Fetch Only Common Records From Two Tables

In this blog, we will see how to fetch common records from two tables in SQL Server, which means the matching records of both the tables will be shown.

I have two tables, which are student and student1. 
  1. Select * from student  
  1. Select * from student1  
  1. (Select * from student) Intersect (Select * from student1)  

Now, you can see in both my tables that only common records are shown in our result set.
In this query, we have used Intersect; if you have knowledge about Algebra, then you must know it well. If you don't know, don't worry about it, as I am explaning it.
Intersecion works on more than one result set. Intersecion is denoted by ∩. Intersection A ∩ B of two
sets A and B is the set, which contains all the elements of A, which also belong to B (or equivalently, all elements
of B that also belong to A), but no other elements. 
Let A={ Orange, pineapple, banana} and
Let B={ spoon,Orange, pineapple, mango}  
A ∩ B = {Orange, pineapple}
Same thing happens in our SQL query but this process is hidden..