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
- 13196 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
Why is there a need for sqlcode and sqlerrm variables?
How do I add a database to sql?
What are the differences between implicit and explicit cursors?
What are crud methods?
Is inner join same as self join?
What is the difference between inner join and natural join?
What is replication id?
Why do we use function in pl sql?
what is the difference difference between procedure and packages
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What are the types of functions in sql?
Which are the different character-manipulation functions in sql?
What does the file extension accdb stand for?
what is the difference between join and union? : Sql dba
what are the features and advantages of object-oriented programming? : Sql dba
