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
15593 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 having clause in sql?

929

Why do we use joins?

986

What is the difference between drop and truncate commands?

999

How much ram can sql express use?

934

Explain the commit statement.

1103

What is the difference between having clause and where clause?

1011

what is the bond code in materialized view?

2933

Why use triggers in sql?

897

what is the difference between a local and a global temporary table? : Sql dba

1006

How to run sql commands in sql*plus?

1081

When do we use triggers?

1027

How do you run a query?

958

What is left inner join in sql?

986

Explain the difference between triggers and constraints?

921

Describe types of sql statements?

993