Select Name,SID from Student where SID in(Select SID from level where leve

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

9 Answers
15809 Views
Oracle, I also Faced
E-Mail Answers

Answer Posted / vishu

Select Name,SID from Student
where SID in(Select SID from level where level='freshman')
and Course=3;

Is This Answer Correct ?

5 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is postgresql a nosql database?

1139

What is information schema in sql?

1053

Difference between global and parameter variables?

1948

How you improve the performance of sql*loader? : aql loader

997

how to create a new view in mysql? : Sql dba

923

How much does a sql dba make? : SQL DBA

927

What pl/sql package consists of?

1059

When to use inner join and left join?

937

What is a unique key?

1034

What is sql entity?

1076

What is $$ in sql?

971

What is before trigger?

987

What do you mean by stored procedures?

995

What is the purpose of cursors in pl/sql?

1122

Explain foreign key in sql?

1006