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
- 13143 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
How do I sort a table in sql?
What is mutating sql table?
How bulk collect improves performance?
what tools available for managing mysql server? : Sql dba
how can we know the count/number of elements of an array? : Sql dba
Can we create foreign key without primary key?
What does the acronym acid stand for in database management?
what is sql profiler? : Sql dba
i have some prob lem to tell me about my self in interview first round ...
How do I find duplicates in the same column?
define data blocks ? : Sql dba
What is input buffer in sql*plus?
How is pl sql different from sql?
Is sqlite thread safe?
Whis is not false in primary key?
