| |
GeekInterview.com > Interview Questions > General > Interests
| Print | |
Question: Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level?
Answer: SELECT Student.name, Student.SIDFROM Student, Level WHERE Student.SID = Level.SID AND Level.Level = "freshman" AND Student.Course = 3; |
| December 12, 2005 06:03:47 |
#2 |
| Asheesh pandey |
Member Since: Visitor Total Comments: N/A |
RE: Given two tables Student(SID, Name, Course) and Le...
|
I think this is the right answer of the above query: SELECT Student.name, Student.SID FROM Student, Level WHERE Student.SID = Level.SID AND Level.Level = "freshman" AND Student.Course = 3; |
| |
Back To Question | |
