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.
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 to convert comma separated string to array in pl/sql?
What is a boolean in sql?
How to place comments in pl/sql?
Is sql procedural language?
how to analyze tables with 'mysqlcheck'? : Sql dba
What are the different parts of a package?
Can we rollback delete command?
How to select 10 records from a table?
what are the advantages of sql ? : Sql dba
Is sqlite good enough for production?
What are functions in sql?
What are the different sql languages?
how is exception handling handled in mysql? : Sql dba
what is the difference between a local and a global temporary table? : Sql dba
How do I get sql certification?