How would you retrieve common records from two tables ?

Question

Pankajkumar Patel · Answer

Hi Naresh Beniwal, INTERSECT can be used in MS SQL to retrieve common records from two tables as like following: SELECT Subject_code FROM students INTERSECT SELECT Subject_code FROM teacher; For more details: How do you fetch common records from two tables in SQL? https://www.quora.com/How-do-you-fetch-common-records-from-two-tables-in-SQL Hope, this will help you!

Uday Dodiya · Answer

Hi Naresh, Use Intersect Key word, which gives you common records. SELECT column1 FROM table1 INTERSECT SELECT column1 FROM table2 If you want in the output both column1 and column2 from table1 which has common columns1 in both tables. SELECT column1, column2 FROM table1 WHERE column1 IN ( SELECT column1 FROM table1 INTERSECT SELECT column1 FROM table2 )

Onkar Sharma · Answer

Hi, To learn about how to find common records from two tables, visit: https://www.sqlshack.com/sql-intersect-use-in-sql-server/ https://www.c-sharpcorner.com/blogs/fetch-only-common-records-from-two-tables Thanks!

Rajanikant Hawaldar · Answer

(Select * from student) Intersect (Select * from student1) https://www.c-sharpcorner.com/blogs/fetch-only-common-records-from-two-tables

Jignesh Kumar · Answer

Hi Naresh, You can use Intersect or Inner Join to get common records from two tables.

How would you retrieve common records from two tables ?

Answers (5)