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
- 13189 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
What is insert command in sql?
What is the difference between sql and t sql?
What are the possible values for the boolean data field?
what is index? : Sql dba
What is trigger types in sql?
What is recursive stored procedure?
How to read/write files from pl/sql?
What is sql performance tuning?
What is the usage of the distinct keyword?
Can we create foreign key without primary key?
When sql appeared?
Explain 3 basic parts of a trigger.
Which is better varchar or nvarchar?
Can we write ddl statements in functions?
How does left join work in sql?
