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
- 13237 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / raksha
select s.sid,s.name
from student s,
level l
where s.sid=l.sid
and s.course = 3
and l.level = 'Freshman'
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to use in conditions? : Sql dba
What is data abstraction in sql?
how to write date and time literals? : Sql dba
Can we use join in subquery?
What is asqueryable?
Does truncate release storage space?
What does pl sql stand for?
What is trigger and stored procedure in sql?
Explain autonomous transaction.
what is the difference between inner and outer join? Explain with example. : Sql dba
Explain normalization and what are the advantages of it?
Do we need commit after truncate?
Is sql a backend language?
how to fetch common records from two tables? : Sql dba
What does <> sql mean?
