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
- 13138 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 many sql dml commands are supported by 'mysql'? : Sql dba
what are myisam tables? : Sql dba
What is the basic form of sql query?
Why self join is used in sql?
How long it takes to learn pl sql?
How many types of functions are there in sql?
How much does sql cost?
What are inner outer left and right joins in sql?
What is a crud api?
Is it possible to update views?
What are dml commands?
What is clause?
Is pl sql better than sql?
What is ttitle and btitle?
Can a trigger call a stored procedure?
