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
- 13162 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / supreeth
SELECT Student.name, Student.SID
FROM Student, Level
WHERE Student.SID = Level.SID
AND Level.Level = "freshman"
AND Student.Course = 3;
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
how to create a test table in your mysql server? : Sql dba
Why do we use joins?
What is function and procedure in pl sql?
Can we rollback delete command?
What is the difference between in and between in sql?
What type of database is sql?
Can we join tables without foreign key?
Can a foreign key be null?
what are the differences between char and varchar? : Sql dba
what is the difference between delete and truncate statement in sql? : Sql dba
What is schema in sql example?
what are null values? : Sql dba
Is ms sql traffic encrypted?
What is sql procedures and functions?
What is nosql vs sql?
