Detailed course structure for each branch and semister
Syllabus for each semester subjects
Previous Mid Exam Question Papers
Previous Semesters Final Exam Question Papers
Which one has better performance... Exists or a sub-query ( IN clause)?
Using exists is faster as it returns a Boolean value checking for the existence of records. Where as an 'IN" clause keeps iterating through all the records even if it gets a correct match. So that's waste of resource.