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
- 16123 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / vishu
Select Name,SID from Student
where SID in(Select SID from level where level='freshman')
and Course=3;
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How do I run sql profiler?
What is the difference between python and sql?
What is nosql db?
How do I start sql from command line?
Why is a trigger used?
How do I pipe the output of one isql to another?
Explain what is a view?
what is the difference between delete and truncate statement in sql? : Sql dba
How do temporal tables work?
What is the purpose of the primary key?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Is and as keyword in pl sql?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
How do I count records in sql?
How many aggregate functions are available there in sql?
