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
- 15873 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
What are the string functions in sql?
Can a varchar be a primary key?
Explain what is a field in a database and record in a database?
Can pl sql procedure have a return statement?
What is rank function in sql?
What is materialized view. What are different methods of refresh?
Enlist the advantages of sql.
What is the difference between in and between in sql?
What are the properties of a transaction?
what is 'mysqladmin' in mysql? : Sql dba
What is a pl/sql block?
Can you have a foreign key without a primary key?
What are actual parameters and formal parameters?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
Does view contain data?
