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
- 13147 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / dharmendra singh
select s.name,
c.SID
from Student s, level c
where s.sid = c.sid
and s.course = 3
and l.level = 'freshman';
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to shutdown mysql server? : Sql dba
How to install oracle sql developer?
how to calculate the difference between two dates? : Sql dba
Can there be more than one function with a similar name in a pl/sql block?
What is a design view?
How to avoid using cursors?
What is the difference between delete, truncate and drop command?
Can I learn sql in a week?
What are properties of the transaction?
what is the functionality of the function htmlentities? : Sql dba
Does a join table need a primary key?
Can we call dml statement in function?
what are the differences between binary and varbinary? : Sql dba
Is inner join same as self join?
How do I view an execution plan in sql?
