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
- 13192 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / ani
SELECT
S.Name
,S.SID
FROM Student S
INNER JOIN Level L ON S.SID=L.SID
WHERE S.Course=3 AND L.level='freshman'
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are sql objects?
Explain the uses of a database trigger?
What is the starting oracle error number? What is meant by forward declaration in functions?
What are operators available in sql?
Can a procedure in a package be overloaded?
what are all types of user defined functions? : Sql dba
Is pl sql still used?
What is write ahead logging in sql server?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
What is aggregate function in sql?
How do you run a query?
What are the sql aggregate functions?
How do I find duplicates in the same column?
How do I filter in sql profiler?
What is sql partition function?
