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
- 14323 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / vishu
Select Name,SID from Student
where SID in(Select SID from level where level='freshman')
and Course=3;
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is nvarchar max in sql?
what is a database transaction? : Sql dba
Differentiate between pl/sql and sql?
Which one is faster ienumerable or iqueryable?
How can the performance of a trigger be improved?
what is a control file ? : Sql dba
what are the different functions in sorting an array? : Sql dba
What are the types of sql commands?
Does a user_objects view have an entry for a trigger?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
How do rank () and dense_rank () differ?
what is blob? : Sql dba
When sql appeared?
What are all the different normalizations?
