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.
- 9 Answers
- 14324 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / guest
SELECT S.Name,S.SID
FROM Student S, Level L
WHERE S.SID=L.SID
AND L.level='freshman'
AND S.Course=3
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is the benefit of foreign key?
What does data normalization mean?
does sql support programming? : Sql dba
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
what is foreign key? : Sql dba
what is bdb (berkeleydb)? : Sql dba
What is sap sql?
what are the type of locks ? : Sql dba
How can you view the errors encountered in a trigger?
How exception is different from error?
how to see the create table statement of an existing table? : Sql dba
What is sorting in sql?
how many triggers are allowed in mysql table? : Sql dba
What is dml and ddl?
Is sql an operating system?
