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
- 14331 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
Is left join inner or outer?
Can you select everything, but 1 or 2 fields, without writer's cramp?
how can we find the number of rows in a table using mysql? : Sql dba
What is varchar sql?
What is the difference between python and sql?
Can you have more than one trigger on a table?
Which command is used to call a stored procedure?
Can I create table without primary key?
What is trigger in sql?
How do I audit the sql sent to the server?
How would you pass hints to the sql processor?
What is the use of prepared statement?
What does 0 mean in sql?
What are the types of records?
What is the difference between jpql and sql?
