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
- 13245 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / debanjan rudra
select stud.name NAME,
stud.sid SID
from student stud,
level lvl
where stud.course = 3
and lvl.level = 'freshman';
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is trigger types of trigger?
how to concatenate two character strings? : Sql dba
What are different types of indexes?
What is the difference between joins?
what is the difference between char_length and length? : Sql dba
What is rank function in sql?
What are instead of triggers?
What are the possible values that can be stored in a boolean data field?
Can triggers stop a dml statement from executing on a table?
What are types of exception?
How do I turn a list into a table?
how do you login to mysql using unix shell? : Sql dba
How do I find duplicates in a single column in sql?
Is left join inner or outer by default?
What is a variable in sql?
