How to fetch same record from two table in SQL Server?

Question

Ashutosh Kumar Verma · Answer

Fetch same Record from Two table: The INTERSECT Operator is used to find the same record from two database in SQL Server. Let us create two table Employees and Manager Employees table: Manager table: Now, the following SQL statement is find the same record from above both table by using INTERSECT Clause, Output:

forum

How to fetch same record from two table in SQL Server?

Can you answer this question?

1 Answers