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
- 13193 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
Can a select statement fire a trigger?
Can a key be both primary and foreign?
Does sqlite need a server?
What is auto increment feature in sql?
Explain correlated query work?
Which table is left in left join?
What is a schema sql?
how to use in conditions? : Sql dba
how can we repair a mysql table? : Sql dba
What is the difference between left join and right join?
Why does sql need a server?
What does over partition by mean in sql?
What is the difference between sql and mysql?
Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)
What does select * from mean in sql?
