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
- 13161 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / raksha
select s.sid,s.name
from student s,
level l
where s.sid=l.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 mutating error in pl sql?
how mysql optimizes distinct? : Sql dba
What does the base_object_type column shows in the user.triggers data dictionary view?
What is relationship? How many types of relationship are there?
How to create your own reports in sql developer?
How do you write a complex sql query?
What are joins in sql?
What is rank () in sql?
What is pl sql collection?
What are the properties of a transaction?
What is the use of sql trace?
What are data types in pl sql?
How to display Row Number with Records in Oracle SQL Plus?
Why do we use set serveroutput on?
How to write pl sql program in mysql command prompt?
