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
- 13244 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
Can I create table without primary key?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What is the requirement of self-join?
What is the difference between inner join and natural join?
Write a sql query to convert all character to uppercase after hypen.
What is interval partition?
How does sql store data?
Does a primary key have to be a number?
What are the sql commands?
How do you remove duplicates without using distinct in sql?
how to select first 5 records from a table? : Sql dba
explain the difference between myisam static and myisam dynamic. : Sql dba
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
How do you update f as m and m as f from the below table testtable?
What is a behavioral trigger?
