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
- 13238 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 can we know the number of days between two given dates using mysql? : Sql dba
What is the difference between syntax error and runtime error?
What is the use of nvl function?
How to add a column ‘salary’ to a table employee_details?
What is a table partition?
what is union? : Sql dba
How to Execute a Package in PL/SQL.?
What does (*) mean in sql?
What is the difference between inner join and outer join?
how is exception handling handled in mysql? : Sql dba
What is a behavioral trigger?
what does the t-sql command ident_incr does? : Transact sql
What is rownum?
What is microsoft t sql?
How do I debug a stored procedure?
