**INTERSECT ** is another Operation in SET that helps to return the common values. For example, in mathematics, if we are assume two sets:

a = {1,2,3,4}

b = {2,3,5,6}

The common elements in both set **a** and **b** are 2 and 3. That means:

a **∩ **b is {2,3}.

## Syntax

```
Statement
INTERSECT
Statement;
```

## Example

For instance, we want to find the Common entry by Name, Roll_No in Stu and Children table as shown below:

**Children** table is shown below:

Reffer to the **Stu** table below:

Now , to find the common intersecting elements:

```
Select Name, Roll_no from Stu
INTERSECT
Select Name, Roll_no from Children;
```

**Output**:

- Log in to post comments