Friday, 18 December 2015

How to fetch common records from two tables?

Common records result set can be achieved by -.
 Select studentID from student. INTERSECT Select StudentID from Exam 1
Select studentID from student. INTERSECT Select StudentID from Exam

No comments:

Post a Comment