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
- 13203 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
how can we optimize or increase the speed of a mysql select query? : Sql dba
What are field types?
What is database migration?
What is the life of an sql statement?
What will you get by the cursor attribute sql%rowcount?
What is a schema? How is it useful in sql servers?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
How can I delete duplicate rows?
What are the basic techniques of indexing?
How many postgresql users are there, worldwide?
Is sql a microsoft product?
what is a database? : Sql dba
What are the advantages of normalization?
What is a variable in sql?
What are the types of variables use in pl sql?
