Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQL Select
I need help with an SQL query to determine which students have taken two or more courses. For example, what is the most efficient way to answer the question: who has taken all three classes CS101, CS200, and CS300?
The tables are as follows (the relationship is one to many):
STUDENT
StudentID
FirstName
LastName
TAKEN
ClassTitle
StudentID
Received on Tue Sep 30 1997 - 00:00:00 CDT