Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15581 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 is type and rowtype in pl sql?
What is substitution variable in pl sql?
How do you optimize a stored procedure in sql?
How can we implement rollback or commit statement in a trigger?
how can we destroy the cookie? : Sql dba
describe transaction-safe table types in mysql : sql dba
What type of join is sql join?
What is t sql used for?
What is a full join?
what is meant by urlencode and urldocode? : Sql dba
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
what is the difference between a web-garden and a web-farm? : Sql dba
Explain the difference in execution of triggers and stored procedures?
how to drop an existing index in mysql? : Sql dba
what is a unique key ? : Sql dba
