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
15941 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

What is database migration?

973

How do I order by ascending in sql?

1026

What are the parameter modes supported by pl/sql?

1112

Does a user_objects view have an entry for a trigger?

1017

What is forward declaration in pl sql?

1086

Can we use views in stored procedure?

1035

How can you know that statistics should be updated?

1079

What is having clause in sql?

969

what are tables and fields? : Sql dba

1059

How do you update f as m and m as f from the below table testtable?

1860

What is data manipulation language?

1193

How do I create an index in word?

1035

What is schema in sql?

955

What is cost in sql execution plan?

988

What is the difference between functions, procedures, and packages in pl/sql?

1054