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.
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
How do you declare a constant?
What trigger means?
what are string data types? : Sql dba
What does varchar include?
What is user in sql?
How many commands are there in sql?
What is denormalization in a database?
How does cross join work?
Does view store data in sql?
Explain the the update statement in sql?
Explain what is sql*plus?
Which function is used to return remainder in a division operator in sql?
Where can I learn sql for free?
how to write date and time literals? : Sql dba
What is cold data?