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
- 13242 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 difference between sql and mysql?
What is the difference between jpql and sql?
What is bulk collect in pl sql?
How much ram can sql express use?
How do I use google cloud in sql?
What is trigger in flip flop?
what is a record in a database ? : Sql dba
What are the most important characteristics of pl/sql?
What are the different types of a subquery?
What is sql prepared statement?
Why do we need cursor in pl sql?
What are its different types of dbms?
Can we create foreign key without primary key?
What is basic structure of pl sql?
What is compound trigger?
