select s.sid,s.name from student s, level l where s.sid=l.sid and s.cou

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.

Question Posted / raksha

9 Answers
15580 Views
Oracle, I also Faced
E-Mail Answers

Answer Posted / raksha

select s.sid,s.name
from student s,
level l
where s.sid=l.sid
and s.course = 3
and l.level = 'Freshman'

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does mysql_real_escape_string prevent sql injection?

907

what is sub-query? : Transact sql

1039

What are the types of triggers in sql?

1016

How do I run a pl sql procedure in sql developer?

912

Does group by remove duplicates?

979

Mention what plvcmt and plvrb does in pl/sql?

1061

define join and explain different type of joins? : Sql dba

898

What is basic structure of pl sql?

985

What is data modelling in sql?

962

what is user defined functions? : Sql dba

975

How to order siblings in oracle hierarchy queries?

980

How can you select unique records from a table?

992

How many functions are there in sql?

962

What jobs use sql?

925

what are the advantages and disadvantages of views in a database? : Sql dba

993