SELECT Student.name, Student.SID FROM Student, Level WHERE Student.SID =

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 / supreeth

9 Answers
15882 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

Please Help Members By Posting Answers For Below Questions

Explain what is a view?

1054

Can I call a procedure inside a function?

1002

what is meant by urlencode and urldocode? : Sql dba

1171

What are the advantages of normalization?

1074

Why is sql*loader direct path so fast?

1099

What is a memo field?

963

How to convert comma separated string to array in pl/sql?

1173

What is cost in sql execution plan?

974

Does pl/sql support create command?

1099

What does the base_object_type column shows in the user.triggers data dictionary view?

1043

How is a process of pl/sql compiled?

1148

explain commit and rollback in mysql : sql dba

1006

What are the benefits of pl sql?

1114

Can a key be both primary and foreign?

989

What are the advantages of sql? Explain

1094