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
- 14330 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / dharmendra singh
select s.name,
c.SID
from Student s, level c
where s.sid = c.sid
and s.course = 3
and l.level = 'freshman';
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are different types of statements supported by sql?
How can use stored procedures in sql?
how tsql statements can be written and submitted to the database engine? : Transact sql
what happens if you no create privilege in a database? : Sql dba
how to convert dates to character strings? : Sql dba
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
How many functions are there in sql?
Write a sql select query that only returns each name only once from a table?
What is example of database?
What are pl/sql cursors?
What is the limitation on the block size of pl/sql?
How do I run a sql trace?
How to place comments in pl/sql?
what is a stored procedure? : Sql dba
What is record type in pl sql?
