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 structural independence and why is it important?
What is an emotional trigger?
What is the basic structure of an sql?
What is right join sql?
Explain the steps needed to create the scheduled job?
What does subquery mean in sql?
how to start mysql server? : Sql dba
Is there a 64 bit version of ssms?
Why do we use joins?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
how to use like conditions? : Sql dba
What is procedure and function?
How many types of normalization are there?
What is the clause we need to add in function body to return variable?
How do I make my sql query run faster?