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
- 13146 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 do you understand by case manipulation functions?
What are the advantages of sql? Explain
What are primary key and foreign key and how they work?
How to return an array from java to pl/sql?
What is trigger and types?
Which are the different character-manipulation functions in sql?
What is sql clause?
how to convert numeric values to character strings? : Sql dba
What are predefined functions in sql?
What is update query?
How can I change database name in sql?
Where is pl sql used?
What is aggregate function in sql?
What is synchronized subquery?
How do you update f as m and m as f from the below table testtable?
