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 / nagendra
select e.sid, e.name from student e, level d where e.course
= 3 and d.level = 'FISHERMAN'
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is natural join in sql?
Enlist the data types that can be used in pl/sql?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
Are views faster than queries?
What are properties of the transaction?
what is innodb? : Sql dba
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
Can a table contain multiple primary key’s?
What are types of joins?
What is the difference between sum and count in sql?
Determine if oracle date is on a weekend?
what happens if null values are involved in expressions? : Sql dba
What is left inner join in sql?
What is trigger explain with example?
how to run 'mysql' commands from a batch file? : Sql dba