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

Differentiate between % rowtype and type record.

1305

How do I remove sql developer from windows 10?

1111

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1234

How can a function retun more than one value in oracle with proper example?

1074

What is the difference between unique and primary key constraints?

1071

What is query execution plan in sql?

1188

What does dml mean?

988

explain mysql aggregate functions. : Sql dba

992

How to use boolean type in select statement?

1077

What is anonymous block in sql?

1120

How to write a query to show the details of a student from students table whose

1000

Mention what are the benefits of pl/sql packages?

1082

What are its different types of dbms?

1007

What are the key differences between SQL and PL SQL?

1215

Is it possible to update views?

959