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
- 13195 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / guest
SELECT S.Name,S.SID
FROM Student S, Level L
WHERE S.SID=L.SID
AND L.level='freshman'
AND S.Course=3
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are the usages of sql?
What are character functions?
What are the two types of exceptions in pl/sql?
Why use stored procedures?
What is scalar function?
When do we use triggers?
What is union and union all keyword in sql?
How to write html code in pl sql?
How do you rank data in sql?
Is time a data type in sql?
What are the two different parts of the pl/sql packages?
Show the cursor attributes of pl/sql.
Differentiate between % rowtype and type record.
Explain what is sql*plus?
Which function is used to return remainder in a division operator in sql?
