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
- 13262 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / supreeth
SELECT Student.name, Student.SID
FROM Student, Level
WHERE Student.SID = Level.SID
AND Level.Level = "freshman"
AND Student.Course = 3;
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What are the set operators in sql?
when MSQL8.0 is in market
Can we use ddl statements in stored procedure sql server?
What is pragma in pl sql?
When sql appeared?
How to rename a table?
When is the update_statistics command used?
How to test for null values?
What is the difference between database trigger and stored procedure?
What is %s in sql?
How you improve the performance of sql*loader? : aql loader
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
Explian rowid, rownum? What are the psoducolumns we have?
What is numeric function sql?
Does user triggers have entry for trigger with compilation errors?
