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
- 13144 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
What found sql?
Does truncate release storage space?
How do I use google cloud in sql?
What is sql and db2?
What are different types of functions in sql?
How do you go back in sql?
how can we know the count/number of elements of an array? : Sql dba
What is the difference between an inner and outer join?
Is primary key a clustered index?
Does inner join return duplicate rows?
What is #table in sql?
Explain normalization and what are the advantages of it?
What is interval partition?
How do you define a foreign key?
What do you understand by pl/sql records?
