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
- 14342 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / nagendra
select e.sid, e.name from student e, level d where e.course
= 3 and d.level = 'FISHERMAN'
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is the need of merge statement?
what are the advantages of mysql in comparison to oracle? : Sql dba
What do you mean by rowid?
What are the types of variable use in pl sql?
how to use like conditions? : Sql dba
what are all the different normalizations? : Sql dba
What is cursor in pl sql?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is plpgsql language?
What is primary key secondary key alternate key candidate key?
How to connect a sql*plus session to an oracle server?
How do I find duplicates in a single column in sql?
How do you respond to dementia behavior?
how to install mysql? : Sql dba
Mention what pl/sql package consists of?
