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
- 14329 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / smriti
select s.name,s.sid from student s,level l
where s.sid=l.sid
and s.course=3
and l.level='freshman'
| Is This Answer Correct ? | 21 Yes | 0 No |
Post New Answer View All Answers
How does join work in sql?
What is database migration?
What is a schema? How is it useful in sql servers?
What is cursor and why it is required?
Are stored procedures faster than queries?
tell us something about heap tables. : Sql dba
What is sp_helptext?
what is csv? : Sql dba
What are stored procedures in mysql?
What are joins in sql?
Explain the difference between drop and truncate commands in sql?
What is pl/sql language case sensitive?
Mention what is the use of function "module procedure" in pl/sql?
Are stored procedures compiled?
How does one use sql*loader to load images, sound clips and documents? : aql loader
