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

What is the difference between inner join and outer join?

1002

what is a stored procedure? : Sql dba

1142

What are all different types of collation sensitivity?

1042

What is a left join?

961

How can you create an empty table from an existing table?

1085

Name some usages of database trigger?

1024

What is a temporal table?

936

What is meant by truncate in sql?

1074

How do I run a sql query?

1031

what is cursor. write example of it. What are the attributes of cursor.

1402

Why do we need view in sql?

994

Mention what plvcmt and plvrb does in pl/sql?

1148

What is the difference between sql and mysql?

1125

what are wild cards used in database for pattern matching ? : Sql dba

1150

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1025